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 |
why unix commands can be divided into internal and external commands?
Which unix command lists files/folders in alphabetical order?
why metadb requires a seperate slice to create Solaris volume manager
what is virtual machine?
if we create a file, in that 10 rows(means 1,2,....9,10 like). i want 7 row exactly, which command use in unix? plz send this question.
What is the syntax of grep command and what is its use?
How to open a Database using Unix Command Please Do Reply
What is the significance of the 'tee' command?
What command is used to switching between users in unix?
What are awk commands?
How do you create a directory in UNIX?
what are the different operating systems available?