16.20 - Setting Up the Teradata Database - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

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 the following sections:

For information on the DDL operator Teradata Parallel Transporter Reference (B035-2436).