Standalone operators perform specialty processes that do not involve sending data to, or receiving data from, a data stream. In other words, standalone operators solely use input data from job scripts as their source.
Standalone operators can perform the following functions:
- Execute DDL and other self-contained SQL statements
- Execute host operating system commands
- Execute a DELETE task on the database
Teradata PT includes the following standalone-type operators:
- OS Command operator
- DDL operator
- The Update operator, when it is executing the Delete Task and if no data is required.
Standalone operators are summarized in Operator Summary. For more information, see Teradata® Parallel Transporter Reference, B035-2436.