Previous Topic Next topic Print topic


NEVERCLOSE

This directive prevents the closing of open statements or cursors at commit or rollback.

Syntax:

[NO]NEVERCLOSE

Parameters:

None

Properties:

Default: NONEVERCLOSE

Comments:

Under NEVERCLOSE (which is not DB2-compatible), the SQL Option Server does not close cursors or open statement when a commit or rollback is encountered. This option is used for performance reasons.

Previous Topic Next topic Print topic