Hi Team,
Please tell me, If i don't declare the cursor in the program
and i have given open and fetch and close, then what error
will get.
Answers were Sorted based on User's Feedback
Answer / ramesh
Rather I say ,Specofically, It will be Identified at Pre
compilation of your COBOL - DB2 source code.
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / dharani
Db2 return code would be -504 since the cursor is not
declared.
-501 - cursor not opened
-502 - opening cursor which is already opened
-503 - update column not specified in cursor while
declaring the cursor for updating some of the columns in
the table.
| Is This Answer Correct ? | 0 Yes | 4 No |
What is the maximum length of sqlca?
Name the different types of Table spaces.
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
What will the COMMIT accomplish?
What is null value in db2?
Why use RUNSTAT Utility?
What is the use of dclgen in db2?
What is a page?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
How to know the primary key of a table without defining the primary key in the table?
How would one remove old reorg information from the DB2 catalog?
How can record locking be achieved in those DB2 versions which do not support it?