Hi All,

a simple question with triggers, how can I verify the SQLCODE in a trigger when issuing a simple select statement for example. I want to do something that looks like this:


set v_ex = (select v from t where bla=3)
if (sqlcode = 0 or sqlcode =100)
then SIGNAL SQLSTATE 'this is an example'

Thanks

if not exists (select 1 from t where bla=3) then
SIGNAL SQLSTATE 'this is an example'
end if

What is the purpose of this trigger?