Determining the attributes of a cursor by using the GET DIAGNOSTICS statement
Using the GET DIAGNOSTICS statement is one way to get information about any open cursors. Alternatively, you can use the SQLCA.
About this task
After you open a cursor, you can determine the following
attributes of the cursor by checking these GET DIAGNOSTICS items:
- DB2_SQL_ATTR_CURSOR_HOLD
- Indicates whether the cursor can be held open across commits (Y or N)
- DB2_SQL_ATTR_CURSOR_ROWSET
- Indicates whether the cursor can use rowset positioning (Y or N)
- DB2_SQL_ATTR_CURSOR_SCROLLABLE
- Indicates whether the cursor is scrollable (Y or N)
- DB2_SQL_ATTR_CURSOR_SENSITIVITY
- Indicates whether the cursor is insensitive or sensitive to changes that are made by other processes (I or S)
- DB2_SQL_ATTR_CURSOR_TYPE
- Indicates whether the cursor is forward (F) declared static (S for INSENSITIVE or SENSITIVE STATIC) or dynamic (D for SENSITIVE DYNAMIC)