anjani shanker
New User
Joined: 26 Jan 2007 Posts: 37 Location: USA
|
|
|
|
Hi,
I need help to find a way for checking the SQLSTATE or SQLCODE for the query being run thru JCL. I am unloading the output of the query into a file and there can be scenario like there is no row returned for the query in use. In such case i just want to put a check on SQLSTATE, so that if no rows are return and there is any fatal error with the query, the rest of job is handled in a different way. |
|