aux_stmts

Default: 25
Range: 0 – 200

Use the aux_stmts parameter to set the number of database API (that is, ODBC or OCI) STMT structures that can be assigned to individual SQL statements. Using multiple database API STMT (statement) structures allows SQL statements to be parsed once and executed multiple times, provided the STMT structure is not reassigned to hold another SQL statement. Increasing the number of database API statements significantly improves processing time, if your system has enough memory.

A value of zero indicates that the DATABridge Client should parse and execute all SQL statements using a single STMT structure.

Note: When using the Oracle client, make sure that the open_cursors parameter defined in the database initialization file for the Oracle instance (initSID.ora, where sid is the name of the instance) is set to a high enough value.