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 the 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.
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.