Defining Standalone Operators
A standalone operator can be used for processing that does not involve sending data to or receiving data from the Teradata PT operator interface, and thus does not use data streams. If a standalone operator is used, it must be:
Table 5 contains a list of Teradata PT standalone operators.
|
Operator |
Description |
|
DDL |
Executes SQL statements before or after the main extract and load job steps, for job setup or cleanup. For example, you can create tables and create indexes before starting a job, or drop work tables, as needed, after a job. |
|
Update (standalone) |
Use the Update operator as a standalone operator only in cases where it is performing the Delete Task and there is no data needed for the DELETE SQL request. |
|
OS Command |
Executes OS commands on the client host system as part of the Teradata PT job execution |
Example:
Following is a simplified example of defining the DDL operator:
Figure 15: Example script for defining the DDL operator