create table t1(
	id integer primary key,
	t1 char( 10 )
);

create table t2(
	id integer primary key,
	idt1 integer,
	t2 char( 10 )
);

create trigger tr_t1 after insert on t1 
	referencing new as new_row
	for each row
begin
	declare mId integer;
	select isnull(max(id), 0 )+ 1  into mId from t2;
	insert into t2 values (mId, new_row.id, new_row.t1);
end;

begin
	declare mC1 integer; declare mC2 integer;
	select count(*) into mC1 from t1;
	select count(*) into mC2 from t2;
	message 'before insert  t1: ' || mC1 || '  t2: ' || mC2 to client;

	begin 
		insert into t1 values( 1 , 'aaa');
	end;
	select count(*) into mC1 from t1;
	select count(*) into mC2 from t2;
	message 'after insert  t1: ' || mC1 || '  t2: ' || mC2 to client;

	rollback;
	select count(*) into mC1 from t1;
	select count(*) into mC2 from t2;
	message 'after rollback t1: ' || mC1 || '  t2: ' || mC2 to client;

	begin atomic
		insert into t1 values( 2 , 'bbb');
	end;
	select count(*) into mC1 from t1;
	select count(*) into mC2 from t2;
	message 'after insert  t1: ' || mC1 || '  t2: ' || mC2 to client;

	rollback;
	select count(*) into mC1 from t1;
	select count(*) into mC2 from t2;
	message 'after rollback t1: ' || mC1 || '  t2: ' || mC2 to client;
end;