How to open a Database using Unix Command Please Do Reply
Answers were Sorted based on User's Feedback
Answer / shradha
|Is This Answer Correct ?||23 Yes||3 No|
Answer / pavithra
Answer for Mysql:
mysql -u uname -h hostname -ppwd
|Is This Answer Correct ?||23 Yes||6 No|
Answer / my name
isql -Uuname -Ppswd -Ddbname -Sdbservername -c
|Is This Answer Correct ?||6 Yes||0 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 / navneet
|Is This Answer Correct ?||4 Yes||0 No|
Answer / pradeep
isql_r -S Servername -U username -P Password
//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)
|Is This Answer Correct ?||0 Yes||1 No|
Answer / srihari
vi or editor command
|Is This Answer Correct ?||0 Yes||3 No|
How to rename files and folders?
What is grep in bash?
How do I use grep to find a file?
what are the different hardwares available?
what does the job command do?
Name the unix command to find how many days the server has been up.
Which command should you use to find the remaining disk space in unix server?
How do I run a whois command?
what is kernel?
What are the commands in UNIX to list the files in a Directory?
What is the difference between Shell Programming and Shell scripting?
fork in unix ?