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 do you repeat a command in terminal?
What is the search command in unix?
What is the use of find command in unix?
Through which command will redirect output to bOth screen and files at the same time?
Which command is used to find whether the system is 32 bit or 64 bit?
What is the protocol for PING command?
What is the command to find maximum memory taking process on the server?
What is in grep command?
what is the significance of "su" command?
What do know about tee command and its usage?
How does one process we can start an executable file? How to get the PID process, which we started?
what is the use of wild cards?