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.
Answer Posted / 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 |
Post New Answer View All Answers
What is check constraint. Explain with example.
Name the lockable units in DB2?
can we view the access paths created by dbrm ? how ? thx
What does db2 blu stand for?
What is database reorganization?
How is the value function used?
Is the primary key a clustered index?
Mention the location where the output received from explain statement is stored.
Is schema the same as database?
Why do we need reorg in db2?
Explain in detail about buffer manager and its functionalities?
What is a Foreign Key?
How can we retrieve the total number of records in RPG & CLLE?
What is cloudant database?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?