Multiple Statements and Pre-parsed SQL Statements

The aux_stmts parameter applies only to the DATABridge Client during update processing (not cloning).

The aux_stmts parameter defines the maximum number of ODBC, CLI or OCI auxiliary statements that can be assigned to SQL statements. Using multiple statements allows SQL statements to be parsed once and executed multiple times, as long as the auxiliary statement is not reassigned to hold another SQL statement.

In general, higher values for aux_stmts result in faster update processing times at the expense of more memory usage. If you have the memory to spare, increase this parameter as needed. The optimum setting for this parameter will depend on the nature of your data.

For details, see aux_stmts.