Declaring Attributes - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-04
dita:mapPath
kyx1608578396289.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities
The following rules describe how to declare attributes in a DEFINE OPERATOR statement:
  • Attributes must be declared in the operator definition when:
    • they are required by the operator.
    • you want to assign a value that is different than the default attribute value.
    • you want the option of assigning an overriding value (for either the default or assigned value) in the APPLY statement.
  • Declaring an attribute requires that you list the attribute name under ATTRIBUTES in the operator definition as follows:
    ATTRIBUTES 
    (
       VARCHAR TraceLevel,
       VARCHAR TenacityHours=0,
       VARCHAR PrivateLogName=’export.log’,
       VARCHAR SelectStmt,
    );
    The use of VARCHAR and INTEGER is optional when the attribute declaration includes a value assignment, such as for TenacityHours and PrivateLogName, above.
  • All required attributes must be declared. Note that most attributes are not required.
  • Optional attributes automatically assume their default attribute values. If the default value for an optional attribute is adequate for the purpose of a job, it need not be declared.
    Not all attributes have default values

For information on operator attributes and default values, see the sections on individual operators in the Teradata Parallel Transporter Reference (B035-2436).