Required Specifications - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.00
Published
November 2020
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
ric1544831938741.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following specifications are required to define an Update job.

Required Syntax for the Update Operator 
Specification Description
TYPE Operator type. Always UPDATE for consumer or standalone operator.

As a consumer operator, which requires a SELECT statement as part of the APPLY statement:

APPLY
'DELETE FROM TABLE table_a WHERE col1 < :col1;'
TO OPERATOR (UPDATE_OPERATOR[1])
SELECT * FROM OPERATOR (READ_OPERATOR[1]);

As a standalone operator:

APPLY
'DELETE FROM TABLE table_a;'
TO OPERATOR (UPDATE_OPERATOR[1]);

The standalone operator must not contain a SELECT statement.

UserName Operator attribute providing the name of the user for the Update operator logon sessions.
UserPassword Operator attribute providing the password associated with the user name.
TargetTable Operator attribute providing the names of the target tables.