redirecting sql query output to a file

sailaja_80 · #1 (**permalink**) 08-19-2009

Hi,

I am executing sql files in my unix shell script. Now i want to find whether its a success or a failure record and redirect the success or failure to the respective files. meaning.

success records to success.log file
failure record to failure.log file.

As of now i am doing like this.
db3 connect to a
db3 connect to b
db2 -tvf "${var[Perforce_Script_Name]}" > $output
grep -v "successfully" "${var[Perforce_Script_Name]}" >suc_Logfile
grep -v "SQLSTATE" "${var[Perforce_Script_Name]}" >fail_Logfile
But i am not able to see any thing in those files. pls help me.

Thanks for your help and time.

Smiling Dragon · #2 (**permalink**) 08-19-2009

Those greps will find every line that does not contain "successfully" in your script and store them in suc_Logfile, and every line that does not contain "SQLSTATE" in the script, in fail_Logfile.

That doesn't sound like what you want.

If I can assume $output is what you want to look over, try this for the grep portion:

Code:

grep "successfully" $output > suc_Logfile
grep "SQLSTATE" $output > fail_Logfile

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Redirecting output of a command to a file	ankitgoel	Shell Programming and Scripting	3	04-13-2009 05:45 PM
Redirecting Both to a file and std output	send2sridhar	AIX	1	09-23-2008 08:22 PM
Redirecting sql select query result to txt file	dolphin123	Shell Programming and Scripting	1	06-25-2008 02:20 AM
Redirecting sql select query result to txt file	dolphin123	Shell Programming and Scripting	1	06-23-2008 07:13 AM
Redirecting output file to a different server.	Stormrider	UNIX for Dummies Questions & Answers	3	09-25-2002 10:59 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by