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

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

Job Objective

Move rows of data containing BLOB/CLOB/JSON data between two Teradata 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 Teradata 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

This job uses the operators shown for the following reasons:

  • Use the SQL Selector and SQL Inserter operators because they are the only operators that can export and load rows containing BLOB/CLOB/JSON data.