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. - 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).