16.10 - Required Specifications - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

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.