DDL Operator Capabilities | Teradata Parallel Transporter - DDL Operator Capabilities - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2023-11-29
dita:mapPath
abr1608578396711.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
Product Category
Teradata Tools and Utilities

The main task of DDL operator is to send SQL statements to the database to perform setup operations prior to executing load or export tasks.

The DDL operator is frequently used to create or drop error tables or indexes required by Teradata PT operators that will perform the main job tasks. You can, for example submit an INSERT…SELECT statement using the DDL operator to move data from one table to another. The DDL operator is also used to perform mini-batch loading tasks.

The DDL operator is neither a producer nor consumer operator. It does not retrieve data records from the Teradata PT data stream nor put records into the data stream. An APPLY statement is used in a Teradata PT job script in which a DDL operator is defined.

Because conditions in the database may change between uses of a particular job script, you should always evaluate the need to add or change the DDL operator in the script before running a particular Teradata PT job.

The following figure shows the DDL operator interface.