set term ^;
CREATE GENERATOR GEN_MY_TABLE_ID
^
CREATE TABLE MY_TABLE (
ID INTEGER NOT NULL
)
^
CREATE OR ALTER TRIGGER MY_TABLE_BI0 FOR MY_TABLE
ACTIVE BEFORE INSERT POSITION 0
as
begin
if (new.id is null) then
new.id = gen_id(gen_my_table_id, 1);
end
^
commit work^