Input

The input for the activity is the following.

Input Item

Datatype

Description

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.

Prepared_Param_*

(name corresponds to name specified in the Prepared Parameters field on the Configuration tab)

varies

The list of 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.

subsetSize

integer

This element is only available when the Process In Subsets field on the Advanced tab is checked. When that field is checked, records are processed in batches and this element specifies the number of records to process in each batch.

This allows you to process smaller batches of rows instead of retrieving one large result set. This element must be used in conjunction with a Repeat Until True loop group for processing the result sets. For more information, see Fetching Subsets of the Result Set.

timeout

number

Time (in seconds) to wait for the query to complete. If the query does not complete in the given time limit, an error is returned.

maxRows

number

The maximum number of rows to retrieve. To retrieve all rows, specify 0.