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 |
Explain the contents that are a part of dclgen.
How to retrieve rows from a db2 table in embedded sql?
What is a plan and package in db2?
What is the use of dclgen in db2?
What is release/acquire in bind?
Describe what a storage group(STOGROUP) is?
what is different three logs in DB2?
How to define the a field which accepts value till 99999.99 in db2
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is a DB2 plan?
What are the three types of page locks that can be held?
Explain various types of locks in db2?