INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

onmode -I 746 will not detect a raised exception -746 inside a
SPL called from a trigger action.

Repro.

set onmode -I 746

create procedure trigaction(p_id int, p_val int,p_switch
integer);

  if (p_switch = 0) then
    raise exception -746,0,"Value not allowed";
  end if
end procedure;


create table sgtest
(
  id serial,
  val integer not null,
  switch integer
) ;


create trigger ins_sgtest insert on sgtest
referencing new as neu for each row
        (
        execute procedure trigaction(neu.id, neu.val,neu.switch)
 );

Then insert to raise the error.

insert into sgtest values (1, null, 0);

It'll give the -746 error but no AF will be generated.

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS prior to 12.10.xC13.                            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* onmode -I 746 will not detect a raised exception -746 inside *
* a SPL called from a trigger action.                          *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

05.03.2019
24.09.2019
24.09.2019

12.10.xC13