Re: multiple statements in a trigger
The following works for us. What is the full errors and the schema of
the tables?
create trigger "informix".tr_on_ins insert on "informix".on
referencing new as new_tab for each row
(
execute procedure "informix".make_event('dins',
'rid', new_tab.rid, 'dins', new_tab.dins, 'An error' ),
execute procedure "informix".audit_sp('I', , new_tab.label_id,
,new_tab.date_added, , new_tab.rid, , new_tab.dins )
);
On Thu, 2004-02-19 at 08:49, tomL wrote:
> rkusenet <rkusenet@sympatico.ca> wrote in message news:<c104ju$1bsrjk$1@ID-75254.news.uni-berlin.de>...
> > tomL wrote:
> > > hello!
> > > i would like to have two stored proc's fire in one stored procedure (insert proc)
> > > is this possible in informix?
> > > this is the syntax i have now but it is incorrect :
> > >
> > > CREATE TRIGGER "informix"."itCCDjob"
> > > INSERT ON "informix"."job"
> > > REFERENCING NEW AS NEW FOR EACH ROW( EXECUTE PROCEDURE
> > > "informix"."ipCCDjob"
> > > ( NEW.id,
> > > NEW.type_cid,
> > > NEW.status_cid,
> > > NEW.cust_role_id,
> > > NEW.rc_role_id,
> > > NEW.batch_date,
> > > NEW.username,
> > > NEW.jobdesc,
> > > NEW.run_day_of_week,
> > > NEW.run_date )
> > > (EXECUTE PROCEDURE "informix".tsp_iud_job(17,NEW.id,1399) );
> > >
> > > thanks for any help!
> > >
> > > tom
> >
> > You forgot to put the comma separating the two procedures
> >
> > CREATE TRIGGER "informix"."itCCDjob"
> > INSERT ON "informix"."job"
> > REFERENCING NEW AS NEW FOR EACH ROW( EXECUTE PROCEDURE
> > "informix"."ipCCDjob"
> > ( NEW.id,
> > NEW.type_cid,
> > NEW.status_cid,
> > NEW.cust_role_id,
> > NEW.rc_role_id,
> > NEW.batch_date,
> > NEW.username,
> > NEW.jobdesc,
> > NEW.run_day_of_week,
> > NEW.run_date )
> > ,
> > (EXECUTE PROCEDURE "informix".tsp_iud_job(17,NEW.id,1399) );
> ++++++++++++++++++++++++++++++
> i have tried several variations, including this one and all come back
> with syntax errors in dbaccess. i called support and they do not
> believe it is possible.
> variation #1 -
> CREATE TRIGGER "informix"."itCCDjob"
> INSERT ON "informix"."job"
> REFERENCING NEW AS NEW FOR EACH ROW( EXECUTE PROCEDURE
> "informix"."ipCCDjob"
> ( NEW.id,
> NEW.type_cid,
> NEW.status_cid,
> NEW.cust_role_id,
> NEW.rc_role_id,
> NEW.batch_date,
> NEW.username,
> NEW.jobdesc,
> NEW.run_day_of_week,
> NEW.run_date )
> ,
> (EXECUTE PROCEDURE "informix".tsp_iud_job(17,NEW.id,1399) );
>
> variation #2 -
> CREATE TRIGGER "informix"."itCCDjob"
> INSERT ON "informix"."job"
> REFERENCING NEW AS NEW FOR EACH ROW( EXECUTE PROCEDURE
> "informix"."ipCCDjob"
> ( NEW.id,
> NEW.type_cid,
> NEW.status_cid,
> NEW.cust_role_id,
> NEW.rc_role_id,
> NEW.batch_date,
> NEW.username,
> NEW.jobdesc,
> NEW.run_day_of_week,
> NEW.run_date )
> ,
> EXECUTE PROCEDURE "informix".tsp_iud_job(17,NEW.id,1399) );
>
sending to informix-list