Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

hana merge without source table

0 Kudos

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.


  • SAP Managed Tags:
0 REPLIES 0