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