return DB2 SQLCODE - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
return DB2 SQLCODE

google unix.com

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
to pick up the Return Code ( RC) from the mailx command and return it to SAS uisng 's	manas6	UNIX for Dummies Questions & Answers	0	06-05-2008 06:44 AM
cp and rm return non zero value	latitude	High Level Programming	7	08-26-2007 08:04 AM
Return Key	chapmana	Shell Programming and Scripting	2	11-29-2006 04:52 AM
FTP return value	Shaz	UNIX for Advanced & Expert Users	7	06-11-2003 04:09 PM
the return value $?	gusla	Shell Programming and Scripting	3	12-08-2002 08:30 PM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

11-16-2005

kjaisan

Registered User

Join Date: Sep 2003

Posts: 11

return DB2 SQLCODE

Hello All,

I have 2 shell scripts.
script1.sh
script2.sh

script1.sh call script2.sh

script2 will connect to DB2 database and execute a insert statement. I am capturing the return value of insert statement in an variable called SQLCODE. I want to return this SQLCODE to the calling script script1.sh

SQLCODE can have negative values and positive values which are more than 255. There should be a way to send the SQLCODE accross the scripts. How do I return or capture the SQLCODE in script1?

exit $SQLCODE or exit $RETCODE does not help.

Thanks for the help. Appreciate it.
-Jai

Bookmarks

« use of ssh in scripts | KSH Scripting »

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:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 01:59 AM.