RE: triggers

Posted in 2005

Bill Dare — Tue, 7 Jun 2005 10:26:55 -0400 — source: Usenet: comp.databases.informix

after the unload in your procedure add: system "cat update-file >>update-file.append" Regards, Bill > -----Original Message----- > From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org] > On Behalf Of christrier > Sent: Tuesday, June 07, 2005 7:41 AM > To: informix-list@iiug.org > Subject: triggers > > I want to create some triggers for my database, one on-update trigger, > an on-insert trigger and an on-delete trigger. > I've already read the manual about how to create triggers. > > My problem is: I want to write the rows that are effected into a file > outside the database. > pseudocode: > on update unload TO 'update-file' select 'the updated row' > > I know that unload overrides the file, maybe it would be possible to > append everything in one file?! > > but i hope my problem is described clear enough?! > > greetings > chris > sending to informix-list