Creating table object filters

Basic Name

The table name for which e-Biz Impact should look. Use this option when you have static tables with fixed names. Enter the table name, or click the down-arrow to select the name from a list of existing tables. Click the ellipsis to open the Table Maintenance window. See “Creating table objects”.

Use FieldObj

Use the data referenced by the field object as the table’s name. (See the Name Mask field description below.) Click the down-arrow to select from a list of existing field objects.

Use Datalink

Use the contents of the datalink as the table’s name. (See the Name Mask field description below.) Click the down-arrow to select from a list of existing datalinks. Click the ellipsis button to open the Datalink Information window. See “Building a datalink”.

Name Mask

This option displays only when you select Use FieldObj or Use Datalink to specify the content of the table’s name.

If you enter nothing, TRAN-IDE places a “%s” mask in this field and e-Biz Impact uses the data value in the selected field object or datalink as the table’s name. If you enter other values with the “%s” mask, e-Biz Impact combines these values to form the table’s name.

• Example 1 – the content of the p_state field object is “CA”, the Name mask field contains only “%s”; the SFM looks for a table file named “CA.TBL.”

• Example 2 – the content of p_state is “CA” and the Name mask field contains “MY%sCC”; the SFM looks for the table file named “MYCACC.TBL.”

Key Column

The column contents that e-Biz Impact should compare for a match against the data in the current blob area.

All Cols

A list of all the table columns.

Selected Cols

A list of the columns to place into the output transaction when the data in the current blob area matches on data in the key column. The column data is placed into the output transaction in the order that the columns display in this list. When there are multiple columns in this list, e-Biz Impact uses the value in the Sep-Fld or Sep-Lit field to separate each column.

Sep-Fld

Use the contents of a field object as the separator between the columns in the Selected Cols list. Type the name of the field object or click on the down-arrow to select from a list of field objects.

Sep-Lit

Use a literal value as the separator between the columns in the Selected Cols list. Type in the character or pattern to use as the separator.

Tokenized Value Table

This field is visible only when you have loaded an old table object into the Table Options window that is in the tag/value or tokenized value format.

Select this option when the entries in the Value fields of the table contain multiple token “columns” of data with each token separated by the same character. An example of tokenized value data is “name^addr^city^st^zip^ID^”.

Col#

This field is visible only when Tokenized Value Table is selected. Enter the number of the token “column” in the Value field that contains the data you want placed into the output transaction. For the example, in a Value entry of “name^addr^city^st^zip^ID^”, token 3 is “city”. If the token in this entry does not exist in the table or is empty, then the filter fails.

Separator

This field is visible only when Tokenized Value Table is selected. Enter the character that separates the token “columns” of data or select the character from the list.