Writing into Files from Stored Procedures

[Marc Aurele Sev]

Hello Everybody,

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.

[Hack]

Welcome to DevX

Here is how to create a log file (which, essentially, is a text file) using a trigger. You should be able to adapt this to your needs.

http://www.sql-server-performance.co...rigger_p1.aspx

[Marc Aurele Sev]

Thanks for your answer ; unfortunately it seems to be specific to SQL Server

My database is Informix.