Writing into Files from Stored Procedures


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Writing into Files from Stored Procedures

Hybrid View

  1. #1
    Join Date
    May 2009
    Posts
    2

    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
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    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
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  3. #3
    Join Date
    May 2009
    Posts
    2
    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, 10:03 AM
  4. Managing Stored Procedures
    By Randy Pearson in forum Database
    Replies: 2
    Last Post: 08-24-2000, 10:54 PM
  5. Replies: 1
    Last Post: 04-12-2000, 11: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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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