VARCHAR ARRAY Tables - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2023-11-29
dita:mapPath
abr1608578396711.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
Product Category
Teradata Tools and Utilities

Target, error, and work table names can be specified in terms of VARCHAR ARRAY types if specifying more than one table, using the following syntax:

VARCHAR TargetTable = ['table1', 'table2', ..., 'tableN']
Using the ARRAY keyword in assigning an array value is optional.
You cannot specify more error or work tables than there are target tables defined, but you may specify fewer. If fewer error/work table names are defined than target tables, the Update operator creates a name for the error/work table:
  • The first error table is ttnameN_ET
  • The second error table is ttnameN_UV
  • The work table is ttnameN_WT, where ttnameN is the name of the corresponding target table
    Target table names are truncated to the maximum number of characters for table names on the database minus 3 characters before the suffixes "_ET", "_UV", or "_WT" are appended to target table names.

For example, if the following is specified when no other error/work table specifications exist,

VARCHAR TargetTable = ['targtable1', 'targtable2', 'thirdtable']

the Update operator creates the following error tables and work tables:

targtable1_ET
targtable1_UV
targtable1_WT
targtable2_ET
targtable2_UV
targtable2_WT
thirdtable_ET
thirdtable_UV
thirdtable_WT

Note that each set of two error tables and one work table belong to a particular target table; the naming convention preserves the uniqueness of the associated target table.

If you specify the following, the Update operator creates the necessary missing table names:

VARCHAR TargetTable = ['ttname1','ttname2','ttname3']
VARCHAR ErrorTable1 = ['error_1']
VARCHAR ErrorTable2 = ['error_2']
VARCHAR WorkTable = ['work_1','work_2']

If you specify more error table names or work table names than there are target table names, the Update operator issues an error message and terminates the job.