how to pull out data from DS_AUDIT table to a .txt file

[vz7rld]

Hi,


I would like to know how to export the data from DS_AUDIT table in to a. txt file.

Thanks.

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

[vz7rld]

Thanks a lot Ray, it worked fine.