MVSFORUMS.com

vivek1983 · Intermediate Joined: 20 Apr 2006 Posts: 222 Topics: 24

Hi,

Is it possible to trap the SQLCODE in REXX after a query is run thru DSNTEP2 utility?

Following are the details:

=> I am calling DSNTEP2 from REXX using queues.

Nic Clouston · Posted: Wed Mar 07, 2007 4:16 am Post subject:

RC is set after each EXECSQL if you used DSNREXX. It is also set if you use ADDRESS TSO "RUN....

Nic Clouston · Posted: Wed Mar 07, 2007 4:23 am Post subject:

Sorry, brain-fade (and so early in the day too!) - SQLCODE is returned in the Rexx equivalent of the SQLCA if you use DSNREXX. I guess for RC what is set is the RC from DSNTEP2 not the SQLCODE. If your output is written to a file then you can 'scrape' that to get the SQLCODE. But maybe someone else has a better solution.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

vivek1983 · Intermediate Joined: 20 Apr 2006 Posts: 222 Topics: 24

Nic Clouston,

I am trying to get some examples on how to use DSNREXX.

Can you provide me some example on how to execute a query using DSNREXX?

Thanks,
vivek G
_________________
Vivek G
--------------------------------------
A dream is just a dream. A goal is a dream with a plan and a deadline. (Harvey Mackay)

kolusu · Posted: Wed Mar 07, 2007 5:54 am Post subject:

Nic Clouston · Posted: Wed Mar 07, 2007 6:01 am Post subject:

Also, I wrote my examples by referring to the DB2 manual - Application Programming and SQL guide and in particular chapter 9
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.