17.00 - DML Commands - Parallel Data Pump

Teradata® Parallel Data Pump Reference

Parallel Data Pump
June 2020
Programming Reference

DML commands appear with their associated INSERT, UPDATE, or DELETE DML statements, together with the IMPORT commands that identify data to be read from the client.

Teradata TPump DML statements support a conditional apply logic similar to MultiLoad, in which DML statements are applied based on record field contents.

Specified DML statements following a DML command apply data from one or more separate data sources. The data sources contain a record for each table row to which one or more statements apply. Each IMPORT command identifies a separate data source, and references LAYOUT and DML commands. The IMPORT command matches records of the data source to the applicable DML statement or statements by means of its APPLY clauses.

The LAYOUT command defines the layout of the records of a data source, using the parameters and a sequence of FIELD, FILLER, and TABLE commands. The DML command identifies an immediately following set of one or more DML statements.

Each DML statement is converted into a macro and used for the duration of the import.

As Teradata TPump reaches the end of one data source, as identified by the IMPORT command, it continues with the next IMPORT command.