webMethods Integration Cloud and Cloud Deployment Documentation 6.0.0 | webMethods Integration Cloud | Applications | Predefined Applications | Database | Database Application Operations | Configuring the Parameter Values | Batch Update Operation
 
Batch Update Operation
You can configure the following parameters for Batch Update 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 Update 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 Update SQL query is successfully executed and returns the rows affected in the database.
*A value of -2. This indicates that the command was processed successfully but the number of rows affected is unknown.

Copyright © 2014- 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.