Advanced

The Advanced tab has the following fields.

Field

Global

Var?

Description

Override Transaction Behavior

Yes

Overrides the default behavior of a transaction group. If this activity is in a transaction group, the activity is normally committed or rolled back with the other transactional activities.

If this check box is selected, this activity is not part of the transaction group and is committed when it completes. Checking this option uses a separate database connection to perform the activity and commit the SQL statement.

Use Nil

No

Specifies whether NULLs are represented as optional schema elements or whether each item that can contain a NULL has sub-items.

For example, in the following schema, the NAME column can contain NULLs. If Use Nil is unchecked, the NAME element appears with a ? indicating it is optional (and if the column is NULL, the schema element is not included for that row). If Use Nil is checked, the NAME element is not optional, and it has two sub-elements, @nil and text(). The @nil element indicates whether the column value for the row is NULL, the text() element contains the column value when the column is not NULL.

Interpret Empty String as Null

No

Specifies how empty strings in the activity’s input elements should be handled. When the field is checked, nulls are sent to the database where empty strings are supplied. When the field is unchecked, empty strings are treated as zero-length strings. Whether you use this field or not, you can still use XPath to set input elements explicitly to null.

Note: Many databases treat empty strings and nulls as the same, so this field does not affect how the database interprets empty strings.

Process In Subsets

No

Checking this field specifies that you would like to process the result set in smaller batches rather than processing the entire result set at once. When this field is checked, the subsetSize input element appears to allow you to specify the size of each batch of records you want to process. Also, the lastSubset output element appears and is set to true when the last batch of records is being processed.

When this field is unchecked, the entire result set is returned.

For more information, see Fetching Subsets of the Result Set.