Example - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
17.00
Published
August 31, 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
zae1544831938751.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following examples compare a single APPLY clause to multiple APPLY specifications. The examples use the syntax discussed in the previous procedure:

  • Single APPLY target:
    APPLY ('INSERT INTO EMP_TARGET1 (:EMP_ID, :EMP_LNAME, :EMP_FNAME, :EMP_DEP);') TO OPERATOR (LOAD_OPERATOR_1)
    SELECT * FROM OPERATOR (EXPORT_OPERATOR_1);
  • Two APPLY targets:
    APPLY ( 'UPDATE table1 SET C2 = :col2 WHERE C1 = :col1;', 'INSERT
    INTO table2 ( :col1, :col2, …)' ) TO OPERATOR ( UPDATE_OPERATOR () [2])
    ,APPLY ( 'INSERT INTO table3 ( :col1, :col2, …)' ) TO OPERATOR (
    LOAD_OPERATOR () [3] ATTR(….))
    SELECT * FROM OPERATOR (EXPORT_OPERATOR_1);