How to open a Database using Unix Command Please Do Reply
Answers were Sorted based on User's Feedback
Answer / pavithra
Answer for Mysql:
mysql -u uname -h hostname -ppwd
Is This Answer Correct ? | 23 Yes | 6 No |
Answer / srinivas panguluri
Answer for DB2:
db2 connect to database_name user schema_name using password
For rest of the SQL queries add db2 as alias
ex: db2 select * from tablename.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / pradeep
in sybase
isql_r -S Servername -U username -P Password
go
//write your query
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / arvind kumar
Sudo -U Postgres psql Database_name;
It will prompt you for password give correct password and
you can access the given database if it exist.
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / kiruthiga
for state database replica in unix(SVM command)
metadb -i
Is This Answer Correct ? | 0 Yes | 1 No |
distinguish between user mode and kernel mode?
What difference between cmp and diff commands?
what is the command to print last 8 lines of any text file.
Name the various commands that are used for the user information in unix.
Explain iostat, vmstat and netstat.
what is the advaantage of each user having its own copy of the shell?
What is the difference between pipe and xargs?
What is merge command in unix?
What does grep v do?
What is the use of awk command in unix?
Which command is used to delete all files in the current directory and all its sub-directories?
Give the command for finding the current date.