Can we declare cursor in Procudere division or open the
cursor in the Working storage section.
Is there any particular rules in the usage of cursors lifecycle
Answer / omkar panda
yes we can declare cursor in procedure division but we cant
open the cursor in working-storage section as it is an
executabale statement.the lifecycle of cursor is as below
1>declare cursor
2>open cursor
3>fetch cursor
4>close cursor
Is This Answer Correct ? | 20 Yes | 2 No |
When can an insert of a new primary key value threaten referential integrity?
How to execute stored procedure in db2 command editor?
Explain about rct.
how will you retrieve first record in table
What is phantom read in db2?
How to define the data items to receive the fetch items for the SQL?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
What Utility is used to migrate DB2 from one release to the next?
How to execute stored procedures?
How would one remove old reorg information from the DB2 catalog?
Can we insert update delete in view?
What are the abend codes occour in ur latest PROJECT in DB2