16.20 - Declaring Attributes - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
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.