Multivalued (Array Type) Attributes
Teradata PT allows specification of multiple values for a few operator attributes. Array attribute values can be specified as part of:
Available array attributes are shown in the following table:
Attribute |
Operator |
ErrorList |
DDL |
|
Load |
|
Update |
TraceLevel |
|
The following examples show how specification of an array value for an attribute would appear in a DEFINE OPERATOR statement or an APPLY statement:
VARCHAR ARRAY TraceLevel = [ 'CLI', 'OPER' ]
VARCHAR TraceLevel = [ 'CLI', 'OPER' ]
TraceLevel = [ 'CLI', 'OPER' ]
The syntax for using one or more array attributes in a DEFINE statement is shown in “Specification of Operator Attributes” on page 60.
Observe the following additional guidelines for use of array attributes.
VARCHAR ARRAY TargetTable = ['table1', 'table2', …, 'tableN']
VARCHAR TargetTable = ['table1', 'table2', …, 'tableN']
TargetTable = ['table1', 'table2', …, 'tableN']
Using the ARRAY keyword in assigning an array value is optional.
VARCHAR FILE_NAMES = ['/first', NULL, '/third']
VARCHAR FILE_NAMES = ['/first', , '/third']
SELECT * FROM OPERATOR (reader ATTR (FILE_NAMES = ['/first', NULL,'/ third'], MODE = 'read')
Note: Use of VARCHAR and INTEGER is optional when specifying an array attribute value. For detailed information on using VARCHAR and INTEGER, see “Syntax Rules” on page 44.
For details about how to use array attributes for a particular operator, see the chapter on that operator in Teradata Parallel Transporter Reference.