Previous Topic Next topic Print topic

Micro Focus Studio Enterprise Edition for Windows > Programming > Mainframe Programming > SQL Option for DB2 > Reference > XDB Directive Options > AUTOCLOSE

AUTOCLOSE

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.

Parent topic: XDB Directive Options
Previous Topic Next topic Print topic