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 are the abend codes occour in ur latest PROJECT in DB2
Can we able to find all the Table names under a Particular Plan?
Which isolation level provides maximum concurrency?
What is the self-referencing constraint?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
how to resolve -811
what is the difference between normal select query and currosor
When reorg is used?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
What do you mean by NOT NULL? When will you use it?
What is buffer pool and list some of them?
On which levels locks can be applied?