how to get SQLCODE ?

regnumber · #1 (**permalink**) 10-14-2008

Suppose I am executing a sql query thru shell script.
DB : IBM DB2

Quote:

db2 "select * from table1 with ur"

If none of the rows are fetched, I will be getting the sql code as 100
If rows > 0 are fetched, I will be getting the sqlcode as 0

Can any one help me how to get this SQL code in unix shell script (in KSH)

Krishnakanth

zaxxon · #2 (**permalink**) 10-15-2008

I don't know the syntax with "WITH", only with "WHERE", etc.
If you db2 SQL query finds at least 1 row, the returncode of your command will be 0, if not it is 1 or at least > 0.
So you can work with testing $? or parse whatever SQL code you are getting by putting your command into a variable maybe like for example

Code:

VAR=`db2 "select something from sometable..."`

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
return DB2 SQLCODE	kjaisan	Shell Programming and Scripting	0	11-16-2005 01:00 PM

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


	Powered by