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.

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.

Resultsets Use Schema

No

Specifies that the design-time must try to fetch the schema when a resultset is expected from a stored procedure call.

When selected, TIBCO Designer tries to invoke the stored procedure with default values and get the metadata for the resultset.

If the check box is not selected, or if TIBCO Designer does not get any metadata, the results can be displayed as ’unknown resultsets’.