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 db2 tables?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
How do we specify index to include or not during bind process.
What is the result of open cursor statement?
What is the syntax required for the creation of a cursor?
What is the purpose of the QUIESE Utility?
How many types of page locks can be held in db2?
What kind of database is db2?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What is catalog database in db2?