create table  моясхема.test_trg_rollback
(
    i integer,
    j integer
)
;
-- solution that works
create trigger моясхема.trg_rollback
after insert 
on моясхема.test_trg_rollback
referencing NEW as n
for each row
when (n.i = n.j) 
    SIGNAL SQLSTATE '75201' ('i must be different from j' )

begin atomic
insert into моясхема.test_trg_rollback values ( 1 , 3 ) ;
insert into моясхема.test_trg_rollback values ( 2 , 3 ) ;
insert into моясхема.test_trg_rollback values ( 3 , 3 ) ;
end

create procedure моясхема.test_tgr_proc (OUT SQLCODE_OUT INTEGER, OUT SQLSTATE_OUT CHARACTER( 5 ))
    language sql
begin 
       DECLARE v_had_errors char( 1 ) default 'N';
       DECLARE SQLCODE                 INTEGER DEFAULT  0        ;
       DECLARE SQLSTATE                char( 5 )  DEFAULT 'ZZZZZ'  ;
      DECLARE CONTINUE HANDLER FOR SQLEXCEPTION  values(SQLCODE,SQLSTATE ) INTO    SQLCODE_OUT, SQLSTATE_OUT;

    insert into моясхема.test_trg_rollback values ( 1 , 3 ) ;
    insert into моясхема.test_trg_rollback values ( 2 , 3 ) ;
    insert into моясхема.test_trg_rollback values ( 3 , 3 ) ;
   
end

call моясхема.test_tgr_proc (?,?)