The following specifications are required to define an Update job.
|TYPE||Operator type. Always UPDATE for consumer or standalone
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) SELECT * FROM OPERATOR (READ_OPERATOR);
As a standalone operator:
APPLY 'DELETE FROM TABLE table_a;' TO OPERATOR (UPDATE_OPERATOR);
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.|