The following specifications are required to define an Update job.
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. |