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 |
How we will execute previous command in vi editor?
Which Command is Used for temprary switch User?
Briefly, how do you install Oracle software on UNIX.
to list a particular line in the file
Which command is used to find whether the system is 32 bit or 64 bit?
What is the use of awk command in unix?
Write a command to display a file’s contents in various formats?
How do you stop a running process?
how will you convert a general file to a hidden file?
What does grep v do?
What command is used to switching between users in unix?
Which command can you use to find the currently running process in unix server?