15.00 - Definition - Parallel Data Pump

Teradata Parallel Data Pump Reference

prodname
Parallel Data Pump
vrm_release
15.00
category
Programming Reference
featnum
B035-3021-034K

Definition

The Teradata TPump job script, or program, is a set of Teradata TPump commands and Teradata SQL statements that alter the contents of the specified target tables in Teradata Database. These commands and statements:

  • Insert new rows
  • Update some or all of the contents of selected existing rows
  • Delete selected existing rows
  • Each Teradata TPump job includes a number of support commands that establish and maintain the Teradata TPump support environment, and a number of task commands that perform the actual database insert, update, or delete operations. These commands and statements identify and describe the input data to be applied to the target table, and then place that data into the target table. These activities may commence anytime after configuring the program as described in “Teradata TPump Support Environment” on page 29.

    Notice:

    In the event of a client failure, the identical script must be resubmitted in order to restart. If the script is edited, a restart will not be permitted.