Integration Cloud 7.0.0 | Applications | Predefined Applications | Database | Database Application Operations | Configuring the Parameter Values
 
Configuring the Parameter Values
 
Custom SQL Operation
Select Operation
Update Operation
Insert Operation
Delete Operation
Stored Procedure Operation
Batch Insert Operation
Batch Update Operation
Custom SQL Operation
You can configure the following parameters for Custom SQL 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.
Note:
Select No Timeout if you do not want to specify the Query Time Out.
Maximum Row
Type the number of rows to be retrieved from a database table.
Note:
Select No Limit to indicate no limit on the number of rows retrieved.
Row Count Field Name
Type the field name of the Row Count Field.
This field specifies the name of the output field whose value contains the number of affected rows while executing an SQL query.
Row Count Field Type
Select the data type of the Row Count Field.