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 java.util.TimeZone.getAvailableIDs(). For the list of valid time zone names, see Time Zone Names .

timeout

number

Time (in seconds) to wait for the statement to complete.