How to catch the output

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to catch the output
# 1  
Old 02-29-2008
How to catch the output

Hi All,

I have a shell script for ex-


sqlplus user/pass << EOF

select x from y;


my question is can I store the value of x in a variable in unix program so that i can user that value in shell script.....

additionally after catching the value i want to perform some activity and again pass it to databse for getting some data....

how can I do that...?

please help!!!!
# 2  
Old 02-29-2008

You can spool the output using spool command
# 3  
Old 02-29-2008
Thanks for you suggestion...

but is thr anyway other than that ......I dont want to spool the output in any file and use it afterwards.......Smilie
# 4  
Old 02-29-2008

any suggestion guys?????//
# 5  
Old 02-29-2008
Maybe this is what you wanted to do ?
print "select * from myTable" | sqlplus user/pass > output_file
print "select * from myTable" | sqlplus user/pass | some other commands

If not then you could try to use 'expect'.

Probably you could do something like
sqlplus user/pass >output_file <<EOF
select * from myTable
but this is not readable IMHO (and I am not sure which from the above would work).

A hint: ksh/sh/etc. don't have database support. Maybe PERL or something else would be a better choice?
In my company I am always seeing that some guys are using incorrect tools (especially some guys from India who knows only C# and tend to make everything in it - like to rewrite unix applications whar require adding extra communication/interface modules.... this is really sad).
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. AIX

Catch Zombie Process

Hi All, Anyone have any shell script to capture the zombie process, as according to the support they need the real time zombie PID, they only provide the kdb (0) > p* |grep -i defunct (0) > p * | grep <hex pid> But this is doesn't seem easy to catch the zombie as it is not always... (1 Reply)
Discussion started by: ckwan
1 Replies

2. Shell Programming and Scripting

catch the output of the URL

Hi all, anybody can help me in this? how to catch the output of the URL in scripting. exmple: if i give the URL: then output should be in onefile newfile.txt thanks in advance.. (6 Replies)
Discussion started by: rajesh_pola
6 Replies

3. Programming

help with C try catch

can someone give me an example of try catch in C, everytime i do it under the main, i get some try undeclared error, and dont know how to fix it... (3 Replies)
Discussion started by: omega666
3 Replies

4. Programming

Catch ctrl+d in C

Hello, I am programming some kind of shell in special distribution of Linux. My trouble comes with programming the sort function. It should work the same like in the standard shell. When you terminate input, there's need to put End Of Transmission character, which is CTRL+D. But I am not able to... (2 Replies)
Discussion started by: samciz
2 Replies

5. Shell Programming and Scripting

Unable to catch the output after core dump and bus error

I have a weird situation in which the binary dumps core and gives bus error. But before dumping the core and throwing the buss error, it gives some output. unfortunately I can't grep the output before core dump db2bfd -b test.bnd maxSect 15 Bus Error (core dumped) But if I do ... (4 Replies)
Discussion started by: rakeshou
4 Replies

6. UNIX for Dummies Questions & Answers

catch unzip errors

Hi everybody, I'm new to linux world and I need your help!! I'm using vi to create a .sh script that process files moving them from a directory to another and unzipping a file. I need to catch errors while moving or unzipping files. For move command, I do: mv -f... (2 Replies)
Discussion started by: Laetitia
2 Replies

7. Shell Programming and Scripting

How to catch the exception on SFTP?

I just want to send files to remote machine via SFTP, my question is: how can I catch the exception when SFTP command error occur? for example: add a log when network interrupt on SFTP put(or failure on rename the remote file etc.). the shell run on linux. (2 Replies)
Discussion started by: younggun
2 Replies

8. UNIX for Dummies Questions & Answers

How to catch the exception

Dear friends, I am transferring some files to a windows system from Unix m/c thru FTP Script given below. echo "open $host quote USER $userid quote PASS $pwd $verbose $type cd $dir bin put $file close quit"|$ftp... (0 Replies)
Discussion started by: Vijayakumarpc
0 Replies

9. UNIX for Dummies Questions & Answers

How to catch the rscyn errors?

Hi, In my code, I am running rsync, if any error comes, I have to wirte the error to temp file and I want to send this temp file content to specified email address, I am getting starnge outpout, can you pls help to solve this? My code is: tempfile=error.`date '+%m%d%Y_%H%M%SGMT'` rsync -az -e... (3 Replies)
Discussion started by: redlotus72
3 Replies

10. UNIX for Advanced & Expert Users

how to catch information in a different environment .....

Hi , under a Telnet connection on AIX system , i'm using an ascii software console (here Lotus Notes admin console). I would run a shell script to catch information thru this admin console , in other words : 1 i run my shell script 2 in this script run the admin console 3 get the new... (10 Replies)
Discussion started by: Nicol
10 Replies
Login or Register to Ask a Question