I have a table with the following columns: id, name, age, address.
I want to do an UPSERT SP on hana that can:
The SP looks like this:
PROCEDURE UPSERT_SP ( ID varchar(10), NAME varchar(20), AGE int, ADDRESS varchar(50):ID,
BEGIN UPSERT "MT_TABLE"AS MT VALUES(
Now, if I call my SP I want this to happen:
I know that the sp I wrote works in SQL Server Manager, but for some reason SAP HANA doesn't let me do this. When I try to activate the sp i get the following error:
column not allowed: MT.NAME
How can I get the result I'm trying to achieve (I've already tried UPSERT with sub-query and it didn't work).