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 setup sudo, only can use for particular date & time only ( for solaris10 )
How to get the last ten lines of a file using awk utility?
What is shrinking file system in AIX where it actually resides?
What does the command '$ls | wc –l > file1' do?
The rm command removes links to file. What does this mean? How then is a file deleted from the file system?
How to setup Disk space as well as memory in solaris10?
what is the command to find out the difference between files and folders?
What is "type" command in unix?what is the functionality??
Is grep faster than awk?
what is exact definition of operating system?
What is the unix command to confirm a remote host is alive or not?
what do you understand by 'building block primitive'?