Causes the SQL Option Server to close all open statements and cursors at COMMIT and ROLLBACK (the DB2 standard).
Restriction:This topic applies to Windows environments only.
Syntax:
[NO]DB2CLOSE
Parameters:
None
Properties:
Default:
DB2CLOSE
Comments:
If the WITH HOLD clause is included in your SQL statement, cursors remain open after a COMMIT, even if the DB2CLOSE preprocessor directive is specified.
Comments:
If the WITH HOLD clause is included in your SQL statement, cursors remain open after a COMMIT, even if the DB2CLOSE preprocessor directive is specified.