Table Create
The Table Create activity creates an empty table on a TIBCO Patterns server. The table’s meta-data (for example, field names) is created, but no rows are added to the table.
General
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. |
Description
Provide a short description for the Table Create activity.
Input
The Input tab has the following fields:
Input Item |
Description |
Name |
The table name. |
Type |
The table type. This can be |
Description |
An optional note to attach to the table. |
ParentTableName |
The parent table name. This is required if the table type is |
Prefilter |
The kind of prefilter used to index the table. This can be |
GpuIndexing |
Set to |
FieldDefinition |
Defines a field that exists in the table. This is required and can be repeated. |
FieldDefinition/Name |
The field name. This is required. |
FieldDefinition/Type |
The field type. This can be |
FieldDefinition/CharacterMapName |
Name of the applicable character map. This is optional. The default value is |
Output
A tableinfo element output has the following fields:
Output Item |
Description |
||||||||||||
Name |
The table name. |
||||||||||||
Type |
The table type. This is |
||||||||||||
Field |
One per field in the table. |
||||||||||||
Field/Name |
The field name. |
||||||||||||
Field/Type |
The field type. This is |
||||||||||||
Field/CharacterMapName |
The name of the character map that applies to the field. |
||||||||||||
Field/DataKB |
The memory used by the field, across all records in the table, in kilo-bytes. |
||||||||||||
Field/CharactersK |
The number of characters in the text fields, across all records, in thousands. |
||||||||||||
Description |
An optional note attached to the table. |
||||||||||||
CheckpointStatus |
A description of the checkpoint status of the table. The following are the possible values:
|
||||||||||||
RecordCount |
The number of records in a table. |
||||||||||||
KeyTreeKB |
Memory used by the table’s key index in kilo-bytes. |
||||||||||||
FieldStructureKB |
Memory used by the table’s field structure meta-data in kilo-bytes. |
||||||||||||
HeaderKB |
Memory used by the table’s header information, in kilo-bytes. |
||||||||||||
IndexKB |
Memory used by the table’s pre-filter index in kilo-bytes. |
||||||||||||
TotalKB |
Total memory used by the table in kilo-bytes. |
||||||||||||
GIP_Filtered |
|
||||||||||||
SORT_Filtered |
|
||||||||||||
PSI_Filtered |
|
||||||||||||
ParentTableName |
Populated if the table is a child table. |
||||||||||||
GpuIndexed |
|
Common Info Properties
The output of all “Info”-type activities includes the following common fields:
Property |
Exception |
TransactionID |
The full ID of the transaction that owns or claims the item. If the item has not been modified or held by an open transaction, this is |
Dirty |
|
Held |
|
Updated |
|
Error Output
The Error Output tab lists the possible exceptions that can be thrown by this activity. See TIBCO ActiveMatrix BusinessWorks Error Codes for more information about error codes and the corrective action to take.