17.00 - Purpose - Parallel Data Pump

Teradata® Parallel Data Pump Reference

prodname
Parallel Data Pump
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-3021-220K

Teradata TPump supports the Teradata SQL EXECUTE statement, which specifies a user-created (predefined) macro for execution. The EXECUTE statement specifies the type of DML statement (INSERT, UPDATE, DELETE, or UPSERT) to be handled by the macro.

The macro named in this EXECUTE statement must reside in the database before the import task starts. Only one DML statement (INSERT, UPDATE, DELETE, or UPSERT) can be specified in a Teradata TPump predefined macro.

The SQL EXECUTE command must be used between the BEGIN LOAD command and the END LOAD command.