Required Specifications - Parallel Transporter

Teradata® Parallel Transporter Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
IntelliFlex
Lake
VMware
Enterprise
Product
Parallel Transporter
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-06-13
dita:mapPath
mjn1691132485167.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
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.