Previous Topic Next topic Print topic


DB2CLOSE

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.

Previous Topic Next topic Print topic