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 to create hardlinks and softlinks on files?
Explain how to use grep command to list find the records of a file containing 10 different strings?
What is the command to find hidden files in the current directory?
What is the use of awk command in unix?
Which mode is used for allowing file write,read and append mode?
what is the functionality of kernel in unix architecture?
how to change a normal file into hidden file
How to check the flavor of UNIX?
Is there a way to erase all files in the current directory, including all its sub-directories, using only one command?
what is the advaantage of each user having its own copy of the shell?
Where LOG fiels resides in AIX and pls tel me how to remove the log file
Why is it called grep?