Micro Focus Enterprise Developer 3.0 for Eclipse > Programming > Mainframe Programming > SQL Option for DB2 > Reference > XDB Directive Options > AUTOCLOSE

AUTOCLOSE

Causes the SQL Option Server to automatically open and close statements after an insert, update, or delete command.

Restriction: This topic applies to Windows environments only.

Syntax:

[NO]AUTOCLOSE

Parameters:

None

Properties:

Default:

AUTOCLOSE

Comments:

Under NOAUTOCLOSE (which is not DB2-compatible), the SQL Option Server allows multiple execution of insert/update/delete commands without closing the statement. Closing is done at commit. This option is used for performance reasons.