Integration Cloud 6.1.0 | Applications | Predefined Applications | Database | Database Application Operations | Configuring the Parameter Values | Batch Insert Operation
 
Batch Insert Operation
You can configure the following parameters for Batch Insert operation:
Parameter
Description
Query Time Out
Type or Select the query time out value in seconds.
This field specifies the number of seconds the database connection will wait for a SQL statement to execute.
Note:
Select No Timeout if you do not want to specify the Query Time Out.
Batch Result Output Name
Type the output name of the Batch Result Output Name.
The output of the batch operation is a string list. Elements in the list appear in the order in which you add the Insert SQL queries for execution in the batch mode. Depending on the JDBC driver you use, the elements in the list contains one of the following values:
*A number greater than or equal to 0. This indicates the insert SQL query is successfully executed and returns the number of rows affected in the database.
*A value of -2. This indicates that the insert SQL query was executed successfully but the number of rows affected is unknown.