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 is the use of nice command?
What does the command '$ls | wc –l > file1' do?
How to create hardlinks and softlinks on files?
How do you copy a directory with many files and folders into another directory?
What are awk commands?
Write a command that will output the sorted contents of a file named in.txt and place the output in another file named out.txt, while at the same time excluding duplicate entries.
Is ‘du’ a command? If so, what is its use?
What does this command do,"$more readme.txt“?
Which unix command lists files/folders in alphabetical order?
how to find largest file?
14 Answers HCL, Microsoft, Thomson Reuters,
fork in unix ?
How to see unused port number in Solaris?