DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Writing into Files from Stored Procedures

  1. #1
    Join Date
    May 2009

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

  2. #2
    Join Date
    Apr 2007
    Sterling Heights, Michigan
    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.

  3. #3
    Join Date
    May 2009
    Thanks for your answer ; unfortunately it seems to be specific to SQL Server

    My database is Informix.

Similar Threads

  1. DB2 Stored Procedures
    By Steve in forum Database
    Replies: 2
    Last Post: 01-30-2001, 05:11 PM
  2. Replies: 1
    Last Post: 10-30-2000, 11:26 AM
  3. Stored procedures and Active X Objects
    By Nicole Hagler in forum Database
    Replies: 0
    Last Post: 09-06-2000, 09:03 AM
  4. Managing Stored Procedures
    By Randy Pearson in forum Database
    Replies: 2
    Last Post: 08-24-2000, 09:54 PM
  5. Replies: 1
    Last Post: 04-12-2000, 10:32 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center