Record Update

The Record Update activity is used to add, modify, and delete records in a TIBCO Patterns table.

The General tab has the following fields:

Record Update Configuration Fields

Field

Module Property?

Description

Name

No

The name of the activity within the process. The default value is record_update.

Patterns Connection

Yes

The path to the shared configuration resource which contains the Patterns Connection information. See Activities Connection.

Batch Size

No

Modifications via the Record-Update activity are batched. This parameter controls the batch size. The batch size impacts performance and availability.

Description

Provide a short description for the Record Update activity.

Input

The Input tab has the following fields:

Record Update Input Fields

Input Item

Description

TableName

The name of the table to update.

DoMaxWork

Set to true() to quietly ignore empty records, records with invalid formats, records with transaction conflicts, and key errors such as deletes or updates of non-existent records or adds of existing records.

Operation

The record operation to perform. The following are the possible operations:

Insert: Records are inserted. Records keys that already exist in the table cause a fault.
Update: Records are updated. Records keys that do not exist in the table cause a fault.
Upsert: New records are inserted and existing records are updated.
Delete: Records are deleted.

This is optional, but if it is not specified, an operation must be specified on each record.

Record

The record to modify. This is optional and can be repeated.

Record/Key

The record key. This is required. For Delete operations, the key is the only required record element.

Record/ParentKey

Key of the record’s parent. On child tables, if this is not populated, the parent key is assumed to be null.

Record/FieldValue

One per field in the table. This is optional and can be repeated.

Record/Attribute

One per variable-attribute in the record. This is optional and can be repeated.

Record/Attribute/Name

Name of the attribute.

Record/Attribute/Value

Value of the attribute.

Output

The output contains the information on the table after the activity completes. See Table Create Output Fields for details.