Job Example 22: Export BLOB/CLOB/JSON Data from One Database Table to Another - Parallel Transporter

Job Objective

Move rows of data containing BLOB/CLOB/JSON data between two database tables.

Data Flow Diagram

The following figure shows a diagram of the job elements for Job Example 22.

Job Example PTS00025, PTS00028 – Export BLOB/CLOB Data from One Database Table to Another

Sample Script

For the sample script that corresponds to this job, see the following scripts in the sample/userguide directory:

• PTS00025: Exporting BLOB/CLOB Data from One Teradata Database Table and Loading It into Another.
• PTS00028: Exporting JSON Data from One Teradata Database Table and Loading It into Another.

Rationale