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 ls -l command & what is the information it gives about user ?
their is a file1,file2 and i want to append file1 data to file2?
What UNIX command will control the default file permissions when files are created?
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 is the nmap command?
what are the different operating systems available?
What does the command ' $who | sort –logfile > newfile' do?
How to setup Disk space as well as memory in solaris10?
Which command is used to copy files?
How to use grep command to list find the records of a file containing 10 different strings?
Which is the command used to find out currently executing Process in UNIX?
What are file permissions in Unix, and how are they represented?