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 DYNSLT keyword? How do you perform selection using DYNSLT
How to create a table using embedded sql?
What is REORG? When is it used?
what is check point and restart Logic ? why do we go for that ??
What is ibm db2 client?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
Define sqlca.
How to define the data items to receive the fetch items for the SQL?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
What is the SQL Communications Area and what are some of its key fields?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.