Re: Help with triggers, please!

Posted in 1998

Topics: Stored Procedures & SPL, Connectivity: ESQL/C, 4GL & Embedded SQL, Triggers, Constraints & Referential Integrity, Jobs, Consulting & Announcements

rjpinto@my-dejanews.com — Thu, 13 Aug 1998 10:46:08 GMT — source: Informix-list mailing list archive (1991-1998)

In article <6qt0it$qf1$1@news-1.news.gte.net>, "Troy Peterson" <tp096255@gte.net> wrote: Hi Troy, <<Earlier Description deleted>> > CREATE TRIGGER createsqltables> INSERT ON prtded > REFERENCING NEW AS new > FOR EACH ROW > WHEN (NOT EXISTS (SELECT * FROM group > WHERE group.group_id = new.group_no)) > ( > INSERT INTO group (group_id) > VALUES (new.group_no) > );> > You can try using stored procedure instead of the single insert statement on the table. That way you can bunch the multiple db update statements into one stored procedure and fire the stored procedure on each insert statement. There are examples listed in the Informix triggers manual. In case you require specific help then let me know. HTH, Ravi... -- Ravi Joseph Pinto Senior Consultant, AFL Infotech usenet mailto:rjpinto@my-dejanews.com -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

Glossary

ESQL/C