var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: TRIGGER and SQLCODE
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'
if not exists (select 1 from t where bla=3) then
SIGNAL SQLSTATE 'this is an example'
What is the purpose of this trigger?