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 |
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is release/acquire in bind?
What are the contents of a DCLGEN?
Which component is used to execute the sql statements?
What does an outer join do?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
What is DCLGEN ?
if i made sme changes in sub pgm wht r the things to be done for this ?
What is a root page?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
Mention the downsides of page level lock.