Writing into Files from Stored Procedures

[MarcAureleSeverus]

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

 

[PHV]

You may use the SYSTEM statement in SPL.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886