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
|
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 When this field is unchecked, the entire result set is returned. For more information, see Fetching Subsets of the Result Set. |