I am doing a upsert using mload and have a question regarding the syntax related to the DML label.
Do we need to give a semicolon at the end of ".DML label label_name" ?
.DML Label UPSERT Do insert for missing update rows; UPDATE DB.EMP_TGT ..
This gives error: "UTY1407 The following SQL statement is invalid for the .DML statement (location40):
Do insert for missing update rows;"
.DML Label UPSERT; Do insert for missing update rows; UPDATE DB.EMP_TGT ..
However, when i do a simple insert without using the "Do insert for missing rows" keyword. The code still works even with a semicoln at the end of DML label.
This works even with a semicolon:
.DML Label INSERT; INSERT INTO DB.EMP_TGT ..
Please give your valuable inputs.
Solved! Go to Solution.