Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | 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 01:00 PM |
 |
|
|
|
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 |
|
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..."` |
| Sponsored Links | ||
|
|
Linear Mode
