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.