Writing into Files from Stored Procedures

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.
.

Relevant Pages

  • Re: Trigger, alternative way to pass variable to trigger
    ... You don't have to execute the setUser command in the master database, ... create trigger trigger name ... to call stored procedure or execute sql commands and let it handle it the ... Pro SQL Server 2000 Database Design ...
    (microsoft.public.sqlserver.programming)
  • Trigger Timeout Loop Issue
    ... In our database code, we have an AFTER trigger on a specific ... since the record is locked by the trigger, the stored procedure ... processing will the stored procedure (and thus the web service) ...
    (comp.databases.oracle.server)
  • Re: Having Trouble with triggers!! ~ Please Help!
    ... >Try changing your trigger. ... >> master database and three satellite using triggers. ... >> I created two test databases, one on the same server ... >> the stored procedure, right?!... ...
    (microsoft.public.sqlserver.replication)
  • Re: Trying to creatively work around 8000 Character limit with sp_executesql
    ... > I have a situation where it would be very handy to use a database ... > trigger to dynamically re-create a stored procedure within our system. ...
    (microsoft.public.sqlserver.programming)
  • Re: chooses not to generate code at all
    ... >>>DBMS is so that the DBMS engine can execute it when triggered by some ... If there is no trigger, ... Stored procedure is one thing. ... > If the procedure execution is not triggered by DBMS ...
    (comp.object)