Page 1 of 1
how to pull out data from DS_AUDIT table to a .txt file
Posted: Mon Jun 16, 2008 10:34 am
by vz7rld
Hi,
I would like to know how to export the data from DS_AUDIT table in to a. txt file.
Thanks.
Posted: Mon Jun 16, 2008 4:30 pm
by ray.wurlod
Execute the following commands. Edit your SQL query to suit your requirements. The first command establishes a "print channel", while the LPTR keyword in the query directs output to that channel. I have used channel #4 in the example; you can use any number between 0 and 255.
Code: Select all
SETPTR 4,132,200000,0,0,3,BANNER ds_audit.txt,BRIEF
SELECT * FROM DS_AUDIT LPTR 4 ;
The text file ds_audit.txt will be in a subdirectory called &HOLD& in your project directory on the server.
Posted: Tue Jun 17, 2008 7:08 am
by vz7rld
Thanks a lot Ray, it worked fine.