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

statement

string

The SQL statement you want to execute. You can use any process variables to build the statement dynamically, if desired.

timeout

number

Time (in seconds) to wait for the statement to complete. If the statement 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.