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:
- 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 Teradata 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:
- Moving External Data into Teradata Database
- Moving Data from Teradata Database to an External Target
- Moving Data within the Teradata Database Environment
For information on the DDL operator Teradata Parallel Transporter Reference (B035-2436).