Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
status information
- Thread starter konsri
- Start date
gregsimpson
Programmer
- Apr 18, 2002
- 521
If your mainframe you could always call DSNTIAR(Batch) or DSNCIAR(CICS) to extract any information in the SQLCA which may be of use to you.
If your on AIX I believe you need to use the sqlaintp function, although I haven't used this myself.
This translates all the information is the SQLCA into more meaningful text and as such can be of use in finding out why your SQL failed.
You will probably still have to do some detective work from the text output, but it usually helps.
If your on AIX I believe you need to use the sqlaintp function, although I haven't used this myself.
This translates all the information is the SQLCA into more meaningful text and as such can be of use in finding out why your SQL failed.
You will probably still have to do some detective work from the text output, but it usually helps.
- Status
Similar threads