DEFINE OPERATOR Statement: Definition
The following example shows a typical DEFINE OPERATOR statement for a standard Teradata PT operator.
The values assigned to the attributes for the DataConnector operator remain in force throughout the job script, except where they are assigned override values in the APPLY statement reference to this operator object.
DEFINE OPERATOR FILE_READER
DESCRIPTION 'TERADATA PARALLEL TRANSPORTER DATACONNECTOR OPERATOR'
TYPE DATACONNECTOR PRODUCER
EXTERNAL NAME 'MyOperator'
SCHEMA ReadFilesSchema
ATTRIBUTES
(
VARCHAR OutputLogFileName,
VARCHAR FileName,
Format = 'Delimited',
VARCHAR OpenMode = 'Read',
VARCHAR FileName,
VARCHAR IndicatorMode = 'Y',
RowsPerInstance = 10000
);
APPLY
Purpose
An APPLY statement defines the operations to be executed by a job or job step.
Each job step can contain only one APPLY statement.
Each APPLY statement has two parts:
followed by,
Note: If the operator in any APPLY clause is a standalone operator, then any DML statements must be self-contained; that is, they must refer to no data external to the DML statements themselves and there can be no query expression.
For examples of typical APPLY statements job script examples Appendix A of Teradata Parallel Transporter User Guide.
APPLY statements support the following:
For information about how to implement multiple APPLY operations in a single job step Teradata Parallel Transporter User Guide.