DROP TABLE HM;

COMMIT WORK;

CREATE TABLE HM (id int NOT NULL,name varchar,PRIMARY KEY(id));

DROP PROCEDURE PROC1;

COMMIT WORK;

"CREATE PROCEDURE PROC1
	(i int)
	RETURNS (ret int)
BEGIN
	IF i IS NULL THEN
		EXEC SEQUENCE SEQ1.NEXT INTO ret;
	ELSE
		ret := i;
	END IF
END";

COMMIT WORK;

"CREATE TRIGGER trig_ins ON hm
	BEFORE INSERT
	REFERENCING NEW ID as new_id
BEGIN
	EXEC SQL PREPARE c1 CALL PROC1(?);
	EXEC SQL EXECUTE c1 USING (new_id) INTO (new_id);
	EXEC SQL FETCH c1;
	EXEC SQL CLOSE c1;
	EXEC SQL DROP c1;
END";

COMMIT WORK;