where will u check for sqlcode ?
Answers were Sorted based on User's Feedback
Answer / shaan
Be sure to include sqlca in working storage section.
Then you can check sqlcode from the copybook variable SQLCODE.
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / guru
If you dont include SQLCA, Define SQLCODE and SQLSTATE as
working storage variables and This will suffice
| Is This Answer Correct ? | 2 Yes | 0 No |
How do I delete a table in db2?
What are the different types of base tables?
What is a cursor?
How to resolve -805 error in DB2?
what is the use of bind parameter, Replace?
What does DSNDB07 database do?
What happens to the PLAN if index used by it is dropped?
Why do we bind in db2?
What will happen, while trying to close the closed cursor.
What is the meaning of -805 SQL return code?
Which component is responsible for db2 startup and shutdown?
Is db2 a mainframe database?