I'm hoping one of you guys can help. We're trying to create a sql script procedure in HANA where we have multiple dml statements grouped together, and based on whether those are successful or not, then we want to either COMMIT or ROLLBACK respectively. This seems like a basic enough function of a dbms, but we're struggling with implementing it. Even adding a COMMIT/ROLLBACK statement in a simple create procedure gives a feature not supported error. I've tried to create this in Studio and hdbsql.
Changed the end line marker to hash. I want auto commit to be off in this case.
DROP PROCEDURE test_ins#
CREATE PROCEDURE test_ins ( ) LANGUAGE SQLSCRIPT AS
INSERT INTO SH_TEMP VALUES (1, 1);
* 7: feature not supported: line 1 col 137 SQLSTATE: HY000
Create statement for table below.
CREATE TABLE HOLLAS.SH_TEMP (KEY INT PRIMARY KEY, VAL INT)#
On HANA SPS05, Studio 48, Client 48