![]() |
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| retrieve value from a file | satish@123 | Shell Programming and Scripting | 1 | 05-17-2008 07:40 AM |
| display the result of wc -l with words before and after the result | melanie_pfefer | UNIX for Dummies Questions & Answers | 3 | 04-30-2008 07:33 AM |
| To retrieve Date/Time from Windows by unix/linux boxes | mpc8250 | Shell Programming and Scripting | 4 | 02-09-2008 12:31 AM |
| Outputting formatted Result log file from old 30000 lines result log<help required> | vikas.iet | Shell Programming and Scripting | 5 | 12-02-2007 10:43 PM |
| how do we retrieve a line from a file in unix | lmadhuri | Shell Programming and Scripting | 2 | 02-07-2007 08:07 AM |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
||||
|
how to retrieve sql result to unix....
Hi,
i would like to retrieve seql result and write it into unix text file like "result.txt" In unix, normally, I type "sql" and get into sql,then type "select....." to run and get the result....then copy and paste into result.txt any possible way to write a script to run it automatically? Thanks all!!!! |
|
||||
|
depends on what database you are using
I am using DB2
so once you connect to db2 run the following on unix prompt: db2 -tvf query.file -z result.file I dont remeber how to implement it on Oracle. But as far I can recollect: sqlplus -s @username/password < $sql_file.sql > $sql_file.log thanks Sumeet |
| Sponsored Links | ||
|
|