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 |
what does a process mean?
What is the use of awk command in unix?
what are the differences between CUI and GUI interfaces?
52 Answers College School Exams Tests, HCL, HP, IBM, IBMR, NIIT, Talco, Wipro,
How to check the flavor of UNIX?
How to get the last ten lines of a file using awk utility?
Give the command to display space usage on the UNIX file system.
Explain command to display different lines that are found when compare two files?
How can you change the owner or group of a file?
Which command is used to delete all files in the current directory and all its sub-directories?
What are the commands in UNIX to list the files in a Directory?
What command is used to switching between users in unix?
What Command will remove a Directory in UNIX?