16.20 - Operator Definition in a Teradata PT Job Script - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

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.

  1. For DEFINE OPERATOR statement syntax, see Teradata Parallel Transporter Reference (B035-2436).
  2. 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:
      • The name of a predefined schema object
      • A deferred schema specification, using SCHEMA *
      • An explicit schema definition that includes all of the column definitions.
      Standalone operators do not extract/load data, so they do not specify a schema.
    • 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.