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:

Table Create Configuration Fields

Field

Module Property?

Description

Name

No

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

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:

Table Create Input Fields

Input Item

Description

Name

The table name.

Type

The table type. This can be Standard, Parent, or Child. The default value is Standard.

Description

An optional note to attach to the table.

ParentTableName

The parent table name. This is required if the table type is Child.

Prefilter

The kind of prefilter used to index the table. This can be GIP, SORT, or PSI. The default value is the default for the TIBCO Patterns server.

GpuIndexing

Set to true() to enable GPU harnessing on the table.

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 SearchableText, NonSearchableText, Date, SearchableDate, DateTime, Integer, Float, or Attributes. The default type is SearchableText.

FieldDefinition/CharacterMapName

Name of the applicable character map. This is optional. The default value is =STD=.

Output

A tableinfo element output has the following fields:

Table Create Output Fields

Output Item

Description

Name

The table name.

Type

The table type. This is Standard, Parent, or Child.

Field

One per field in the table.

Field/Name

The field name.

Field/Type

The field type. This is SearchableText, NonSearchableText, Date, SearchableDate, DateTime, Integer, Float, or Attributes.

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:

Last Checkpoint: yyyy/mm/dd-HH:MM:SS if the table was checkpointed
Never Checkpointed if the table is not checkpointed
Checkpoints Disabled if check-pointing is not enabled on this server
No Checkpoint Info if there was an error.

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

true() if the table has a GIP prefilter index. It is false() otherwise.

SORT_Filtered

true() if the table has a SORT prefilter index. It is false() otherwise.

PSI_Filtered

true() if the table has a PSI prefilter index. It is false() otherwise.

ParentTableName

Populated if the table is a child table.

GpuIndexed

true() if the table GPU harnessing is enabled.

Common Info Properties

The output of all “Info”-type activities includes the following common fields:

Table Common Information Properties

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 0.

Dirty

true() if the item has been added, updated, replaced, or deleted by an open transaction.

Held

true() if the item is held by an open transaction because an update on another item is dependent on this item.

Updated

true() if the contents of the item were modified by an open transaction.

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.