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:
Field |
Module Property? |
Description |
Name |
No |
The name of the activity within the process. The default value is |
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:
Input Item |
Description |
||||||||||||
TableName |
The name of the table to update. |
||||||||||||
DoMaxWork |
Set to |
||||||||||||
Operation |
The record operation to perform. The following are the possible operations:
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.