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 functions of zambie process?
Explain the steps that a shell follows while processing a command.
Can you enlist some commonly used network commands?
Assume that a file’s permissions give you read and write access. What operations can you perform on the file if it is in a directory which has “r”(read) only process? What operations can you perform on the file if it is in a directory which has “x”(execute) only access?
How to install scsi driver in unix? give me explanation clearly?
Is there any command in Unix, other than:ls, to list the files in a directory? The answer will be highly appreciated...
what is the use of "test" command in unix?
What is the unix command to confirm a remote host is alive or not?
When i run a programm of orphan process. Instead of getting child's parent (ppid)=1 ..i get 1400 and it varies as per system. How can i findthe right soluion??? My pgm: #include<stdlib.h> # include <stdio.h> int main() { int pid; pid=fork(); if(pid < 0) {exit(-1);} else if(pid==0) { printf("Child Process is Sleeping ..."); sleep(10); printf("Orphan Child's Parent ID : %u ",getppid()); } else { printf("Parent Process Completed ... %u ",getpid()); exit(0); } return 0; } Output:
what are the different operating systems available?
What is the basic difference between unix and windows operating systems?
43 Answers Bopro, College School Exams Tests, CTS, IBM, IT-Kids, Priyadarshini, Sybian Technologies, Tolani Maritime,
how unix kernel distinguishes between a normal file and device file ?
7 Answers Google, IBM, McAfee, Vodafone,