hold statements

Specify whether statements remain open after a commit.

USYS$Mnemonic_PARAMS = hold statements : on | off

USYS$Mnemonic_PARAMS = hs : on | off

Use

Applies to	Mnemonic	Connector Syntax
DB2 connector	DB2	`USYS$DB2_PARAMS`
ODBC connector	ODx	`USYS$ODx_PARAMS`
MS SQL Server connector	MSS	`USYS$MSS_PARAMS`
MySQL connector	MQL	`USYS$MQL_PARAMS`

Description

By default, when a commit is performed, the current hit list is truncated, and the statement used to retrieve it is discarded.

If hold statements is set on, the current statement remains open, and the complete hit list remains available, so it is possible to fetch the next items in the hit list.