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 |
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. |