Setting up the 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 comprises two parts:
- Define the DDL operator
- In the APPLY statement for the step that references the DDL operator, enter the SQL statement that will execute the setup in the database, for instance a CREATE TABLE statement.
The DDL operator is shown in a preliminary step for most job examples shown in the following sections:
For information on the DDL operator, see Teradata® Parallel Transporter Reference, B035-2436.