Unanswered: Problem with BEGIN ATOMIC within trigger body
We are having hard time with Zos Db2 triggers, when I run below mentioned query, I get a error message saying that BEGIN ATOMIC is not supported.
Below is the query that we are struggling with.
--#SET DELIMITER ~
CREATE PROCEDURE @METADI2.I27_SP(IN NEW_VAL_COTF_USUINTER CHAR(10)) LANGUAGE SQL
DECLARE SYNCPOINT INTEGER DEFAULT 0;
SET SYNCPOINT = NEXT VALUE FOR @METADI2.CLSyncSEQ;
So can any one kindly let me know whether BEGIN ATOMIC is not supported within procedure body? Also where can I get detailed SQL reference for ZOS.