triggers dump to text file

I have a need for a trigger to cause output to a text file. The trigger I attempted was create trigger ins_testinsert on test referencing new as new_test for each row(output to foo select * from test where fieldname=new_test.fieldname) It appears Informix doesn't like 'output' in the trigger. Anybody know how to get around this? According to the docs, output and unload are also not welcome in stored procedures. I am currently looking into using trace in a stored procedure, but I feel like I am missing something. Thanks for any help Larry DiGiovanni