SAP HANA Insert or Update Data Based on condition SQL Queries Example
Here is a way to decide whether to insert or update data on the condition of a variable content.
Example
CREATE PROCEDURE PROC_INS_UPT (IN ID INTEGER, IN NAME VARCHAR(20), IN AGE INT)
AS
BEGIN
DECLARE VI_ID_FOUND INT = 1;
SELECT count(*)
INTO VI_ID_FOUND FROM TABLE_TEST WHERE ID = :ID;
IF :VI_ID_FOUND =
0
THEN
INSERT INTO
VALUES
(:ID, :NAME,:AGE);
ELSE
UPDATE TABLE_TEST SET AGE = :AGE WHERE ID = :ID;
END IF;
END;