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 |
What are the three DB2 date and time data types and their associated functions?
how to fetch first 100 rows in db2
What are db2 tables?
How do you check for a null value in a db2 column?
How do you retrieve the data from a nullable column?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is the purpose of the QUIESE Utility?
Name some fields from SQLCA.
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
Can you use max on a char column?
What does reorg do in db2?
what is the difference between declaring the cursor in WS section and Procedure division?