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.