open statements

Specify the number of statements held open by the connector.

USYS$Mnemonic_PARAMS = open statements : Number

USYS$Mnemonic_PARAMS = os : Number

Arguments

Number—the number of statements to be held open. If not specified, the default number of statements maintained is 128.

Use

Applies to

Mnemonic

Connector Syntax

DB2 connector

DB2

USYS$DB2_PARAMS

ODBC connector

ODx

USYS$ODx_PARAMS

MS SQL connector

MSS

USYS$MSS_PARAMS

MySQL connector

MQL

USYS$MQL_PARAMS

Description

This option specifies the number of statements that the connector maintains in administration before closing the last recently used one.