Required Specifications - Parallel Transporter

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.