I have a requirement to execute two standalone update operations on same target table using TPT. This is independent of any other data source
Update tableA Set col1 = 'xyz' where col3 < currentdate;
Update tableA Set col2 = 'abc' where col4 = currentdate;
1) While using Update operator I am getting syntax error
A_Update_Operator: Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword between the 'USING' keyword and the 'Update' keyword.
2) I tried using DDL operator and the SQLs are executed, but the row counts of update action is not displayed in the log which is required for some validations.
Please suggest how to resolve this.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.