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 |
What is phantom read in db2?
When is the skeleton cursor table created?
Before you give the explain statement, what are the prerogatives?
can any body explain about plan and pakage in detail....
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is isolation level in db2?
What is view db2?
What is a bind in db2?
What does an outer join do?
Are view updateable?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?