This statement attribute determines if the cursor for this statement will be defined with the equivalent of the CURSOR WITH HOLD clause.
Resources associated with statement handles can be better utilized by DB2 CLI if the statements that do not require CURSOR WITH HOLD are set to SQL_CURSOR_HOLD_OFF.
Note: | Many ODBC applications expect a default behavior where the cursor position is maintained after a commit. |