Skip to Content
0
Feb 13, 2019 at 01:18 PM

hana merge without source table

44 Views

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.