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 can we use grep command in unix?
What is “chmod” command?
What is time_t?
Is command prompt unix?
How do you change file permissions?
Explain the read, write, and execute permissions on a UNIX directory.
Give the command for finding the current date.
What is use of sed command?
12 Answers BitWise, Infosys, Reliance,
in UNIX ,What is the command to view contents of a large error log file?
Why is shebang used?
How can i know my Filesystem and its current usage in my prod UNIX system?
Give command that will make the file "run.sh" executable?