What Is The Function Of Open Cursor Command?

1.	What Is The Function Of Open Cursor Command?
Answer» The FOLLOWING operations occur when the OPEN cursor command is EXECUTED for a cursor: Memory area for PROCESSING is allocated The SELECT statement is parsed The INPUT variables are assigned the values by obtaining the memory addresses The active set of rows that fulfill the select criteria are identified The pointer is set just before the first row of the active set The following operations occur when the OPEN cursor command is executed for a cursor:

Answer»

The FOLLOWING operations occur when the OPEN cursor command is EXECUTED for a cursor:

The following operations occur when the OPEN cursor command is executed for a cursor:

Discussion