The following operations occur when the OPEN cursor command is executed for a cursor:
a. Memory area for processing is allocated
b. The SELECT statement is parsed
c. The input variables are assigned the values by obtaining the memory addresses
d. The active set of rows that fulfill the select criteria are identified
c. The pointer is set just before the first row of the active set.
a. Memory area for processing is allocated
b. The SELECT statement is parsed
c. The input variables are assigned the values by obtaining the memory addresses
d. The active set of rows that fulfill the select criteria are identified
c. The pointer is set just before the first row of the active set.