Setting up the Teradata Database can be done in a preliminary job step, using the DDL operator. Most jobs require the use of the DDL operator to perform such setup each time the job is run. The database setup task is comprised of two parts:
1 Define the DDL operator
2 In the APPLY statement for the step that references the DDL operator, enter the SQL statement that will execute the setup in the Teradata Database, for instance a CREATE TABLE statement.
The DDL operator is shown in a preliminary step for most job examples shown in Chapters 5 through 7.
For information on the DDL operator Teradata Parallel Transporter Reference.