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.
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.