|
|
|
google unix.com
|
|||||||
| Forums | Casino | Register | Forum Rules | Links | Albums | FAQ | Members List | Search | Today's Posts | Mark Forums Read |
|
|
|
|
| UNIX for Advanced & Expert Users Expert-to-Expert. Learn advanced UNIX, UNIX commands, Linux, Operating Systems, System Administration, Programming, Shell, Shell Scripts, Solaris, Linux, HP-UX, AIX, OS X, BSD. |
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 12:00 PM |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
10-14-2008
|
|||
|
|||
|
how to get SQLCODE ?
Suppose I am executing a sql query thru shell script.
DB : IBM DB2 Quote:
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 
|
| Sponsored Links | |||
|
|
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..."`
|
||||
| Google The UNIX and Linux Forums |
|
| Bookmarks |
| Tags |
| None |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
