Answer Posted / vinod babu bachina
In DB2 cursor is used to fetch more than one row from a DB2
table. But cursor can fetch only one row at a time. Suppose
if ur retrieving more than one row from table , u have to
use cursor only. If u use SELECT instead of cursor then it
leads to error '' more than one row selected in select'.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a system catalog table in db2?
Can we insert update delete in view?
What is ibm db2 used for?
How to view db2 table structure?
What is release/acquire in bind?
How do I copy a table in db2?
How to test SQL -911 error while developing COB-DB2 program
How to take backup of table in db2?
What is database manager in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Is db2 a database?
Explain in detail about buffer manager and its functionalities?
What is the difference between cursor and select statement?
What is a trigger in the db2 database?