after the unload in your procedure add:

system "cat update-file >>update-file.append"

Regards,
Bill


> -----Original Message-----
> From: owner-informix-list@iiug.org [SMTPwner-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