Specification of Operator Attributes
The specification of operator attributes in a DEFINE OPERATOR statement identifies the attributes that require specified values or that must use other than default attribute values.
Attribute specification requires two actions; declaring attributes and assigning attribute values.
Declaring Attributes
The following rules describe how to declare attributes in a DEFINE OPERATOR statement:
ATTRIBUTES
(
VARCHAR TraceLevel,
VARCHAR TenacityHours=0,
VARCHAR PrivateLogName=’export.log’,
VARCHAR SelectStmt,
);
Note: The use of VARCHAR and INTEGER is optional when the attribute declaration includes a value assignment, such as for TenacityHours and PrivateLogName, above.
Note: Not all attributes have default values.
For information on operator attributes and default values, see the chapters on individual operators in the Teradata Parallel Transporter Reference.
Assigning Attribute Values
The following rules describe how to assign attribute values to attributes declared in a DEFINE OPERATOR statement:
Note: If an attribute value is assigned in the operator definition and is also assigned in the APPLY statement, the APPLY value overrides the value in the operator definition. The override value applies only to the occurrence of the operator where the override value is assigned. All other occurrences in the script are unaffected. For further information, see “Attribute Value Processing Order” on page 63.
@<jobVariableName>
, then the variable will be replaced by the value from the highest priority job variable
source.
For further information on setting job variables and the processing order of job variable sources, see “Specifying Job Variables for Attribute Values” on page 63.