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 null indicator in cobol db2?
When reorg is used?
What is the physical storage length of time data type?
What is lock contention?
What is the use of reorg in db2?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
How do you concatenate the firstname and lastname from emp table to give a complete name?
what is consistency token
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
What is an instance database?
What is IMAGECOPY ?
How to find last record before record through SQLRPGLE?