Teradata PT operators must be defined in the declarative section of a job script, using a DEFINE OPERATOR statement.
Use the following procedure when defining an operator in a Teradata PT job script.
- For DEFINE OPERATOR statement syntax, see Teradata Parallel Transporter Reference (B035-2436).
Specify the required syntax elements:
- The operator name (a maximum of 255 characters with no spaces) is the name by which the job steps reference the operator.
- The operator TYPE, for example LOAD or UPDATE.
- The schema name, which can be either:
Standalone operators do not extract/load data, so they do not specify a schema.
- The name of a predefined schema object
- A deferred schema specification, using SCHEMA *
- An explicit schema definition that includes all of the column definitions.
- The declaration of all the attributes required by the operator with the associated values.
All mandatory attributes must have values associated with them in the DEFINE OPERATOR statement.
For attribute definitions and syntax, see Teradata Parallel Transporter Reference (B035-2436).
- The declaration of any optional attributes that are meaningful to the operator with the optional assignment of values. An optional operator description, which can be defined in a Teradata PT job script after the operator name is defined, provides a short description of the operator to differentiate it from other operators of the same type. For instance, you may define several Load operators that are each configured to do a unique type of load job.