JDBC Programmer Reference › Batch Updates › Using Batch Updates › PreparedStatement.executeBatch()

PreparedStatement.executeBatch()

The JDBC driver uses the CA IDMS bulk input feature to execute INSERT statements. This allows an INSERT statement to be executed with multiple sets of parameter values in a single request. The number of sets of parameter values is limited by the maximum fetch buffer size. Because CA IDMS does not currently support bulk input for UPDATE and DELETE commands, the JDBC driver caches the parameter values and executes these commands individually for each set of values.