aux_stmts

Default: 25
Range: 0 – 200

Use the aux_stmts parameter to set the number of database API (that is, ODBC or OCI) statements that can be assigned to individual SQL statements. Using multiple database API statements allows SQL statements to be parsed once and executed multiple times, provided the statement 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 database API statement.

Note: 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. The session uses one additional statement for all control table updates.