appserver/tests/v2-tests/appserv-tests/devtests/cmp/unknownpkVC/sql/unknownpkVC_ifx.sql

DROP TRIGGER T_UNKNOWNPKVC1;
DROP TRIGGER T_UNKNOWNPKVC2;

DROP TABLE UNKNOWNPKVC1;
DROP TABLE UNKNOWNPKVC2;

CREATE TABLE UNKNOWNPKVC1
(
    ID     DECIMAL(32)          	PRIMARY KEY,
    NAME   VARCHAR(32) 	,
    VERSION   DECIMAL(19)  	NOT NULL 
);

CREATE TABLE UNKNOWNPKVC2
(
    ID     DECIMAL(32)          	PRIMARY KEY,
    NAME   VARCHAR(32) 	,
    VERSION   DECIMAL(19)  	NOT NULL 
);

commit;

CREATE TRIGGER T_UNKNOWNPKVC1
   UPDATE ON UNKNOWNPKVC1
   REFERENCING OLD AS old NEW AS new
   FOR EACH ROW
       WHEN (new.VERSION = old.VERSION)
       (
           UPDATE UNKNOWNPKVC1 SET VERSION = old.VERSION + 1
       );
/

CREATE TRIGGER T_UNKNOWNPKVC2
   UPDATE ON UNKNOWNPKVC2
   REFERENCING OLD AS old NEW AS new
   FOR EACH Row
       WHEN (new.VERSION = old.VERSION)
       (
           UPDATE UNKNOWNPKVC2 SET VERSION = old.VERSION + 1
       );
/

commit;

quit;