The DEFINE OPERATOR syntax order is important.
|attributeName||The name of an attribute that is meaningful to the operator being defined.
For example, the value of the attribute name supplies the operator with required information, invokes an optional operator feature, or otherwise helps to direct the activities of the operator during job execution.
|Required keyword introducing a list of attribute declarations for the defined operator object.
For information on available attributes and required syntax the chapters describing the individual operators beginning with DataConnector Operator.
|attribute declaration list||Required. Excerpt representing a list of the attribute declarations for the operator object.
Observe the following when declaring attributes:
For detailed strategy on how to determine the most useful locations for assigning attribute values “Declaration of Operator Attributes” in Teradata Parallel Transporter User Guide (B035-2445).
For the attribute descriptions and syntax the chapters describing the individual operators beginning with DataConnector Operator.
|DEFINE OPERATOR||Required keyword phrase specifying the beginning of the operator definition.|
|DESCRIPTION 'descriptionString'||Optional keyword phrase providing a descriptive comment about the defined operator object.|
|EXTERNAL NAME 'operatorFileName'||Keyword phrase indicating the actual name of a generic or custom operator library file.
This attribute is required if specifying a generic or custom operator type (for example, TYPE CONSUMER), and not required if specifying a standard, predefined operator type (for example, TYPE STREAM).
|integerValue||An integer that is a valid value of the operator attribute being declared: INTEGER type attribute attributeName.|
|operatorObjectName||Required internal Teradata PT metadata name of the defined operator object.|
|standard operator specification||Excerpt representing a list of the standard operator type specifications for the TYPE specification.
Excerpt representing a list of the standard operator type specifications for the TYPE specification.
Specify one of the following:
|stringValue||A character string that is a valid value of the operator attribute being declared: VARCHAR type attribute attributeName.|
|generic operator specification||Excerpt representing a list of the generic operator type specifications for the TYPE specification.
Specify one of the following depending on how the operator functions:
If one of the above generic custom operator types is specified, then EXTERNAL NAME is also required.
|Keyword phrase identifying a Teradata PT schema, previously defined in the job script, or *, deferring schema identification until run time.
Observe the following operator schema requirements:
|TYPE||Required keyword specifying the type of operator object to be used in the job.
Using the form TYPE <operator specification> specify a standard, predefined operator, or a generic operator.
A schema specification is required except for standalone operators.