Retrieving data from command line

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vinodhraj
Participant
Posts: 53
Joined: Mon Sep 12, 2005 6:51 am

Retrieving data from command line

Post by vinodhraj »

Hi,

I want to write data into a text file which is obtained from ds administrator command line.

for eg

SELECT * FROM DS_AUDIT

The results has to be populated into a text file.

Any solution

Thanks

Vinod
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Vinod,

I would use the COMO command in TCL. This duplicates all screen IO to a file until turned off.

Code: Select all

COMO ON {TextFileName}
SELECT * FROM DS_AUDIT
COMO OFF
The file will be created in the project's &COMO& subdirectory as {TextFileName}.
Post Reply