I'm trying to write the result set of a sql query into a file, from a stored procedure.
My purpose is to make possible this : when an external program access to my database, a trigger is called. This trigger then backups the result set of the query into a file.
I have no idea of how to write a file from a trigger or a stored procedure, so any help is welcome
PS : my database is Informix.