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 difference between Static call and Dynamic call? How does it function?
Explain about rct.
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Can you Average the Characters ?
What is correlation names?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
If I have a view which is a join of two or more tables, can this view be updateable?
how to unload different table data into different gdg files/ vsam files.
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
How to resolve -818 sql code in DB2?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?