02-13-2019 1:18 PM
HI,
Is there a way to use the MERGE command in HANA without a second table as source? I can't use store procedures in this case, it has to be done in one command.
In SQL this can be done like this:
MERGE TARGET_TABLE AS I
USING (VALUES ('VALUE1', 'VALUE2')) AS S(COL1, COL2)
ON I.COL1 = S.COL1
WHEN MATCHED THEN...
WHEN NOT MATCHED THEN...
Thanks.