Input
The input for the activity is the following:
Input Item |
Datatype |
Description |
Record |
repeating |
When batch updates are performed, the list of prepared parameters are contained in a repeating element. When only one update is performed, the list of prepared parameters appears as individual input elements. For more information about batch updates, see the description of the Batch Update field on the Advanced tab. |
Prepared_Param_* (name corresponds to name specified in the Prepared Parameters field on the Configuration tab) |
varies |
The list of the prepared parameters supplied in the SQL statement. Prepared parameters allow you to substitute process data for items in the SQL statement. See the description of the Prepared Parameters field on the Configuration tab. |
ServerTimeZone |
string |
Specifies the time zone for the database server. For more information about how time zones are constructed using this field, see Time Zone Construction. You can use the Constants tab in the XPath Formula Builder to supply a valid time zone name. The list of time zone names is generated from |
timeout |
number |
Time (in seconds) to wait for the statement to complete. |