Find Pointers - created out of account directory

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

There is a pre-stored command for listing remote hashed files.

Code: Select all

LISTFR
Slightly more accurate, since LISTFR includes the DSEngine directory, would be

Code: Select all

SELECT F0 AS HashedFileName, F2 AS PathName FMT '50L' FROM VOC WHERE F1 LIKE 'F%' AND F2 LIKE '%/%' AND F2 NOT LIKE '%DSEngine%';
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
joycerecacho
Participant
Posts: 298
Joined: Tue Aug 26, 2008 12:17 pm

Post by joycerecacho »

Hi my friend!
That was exactly what I needed.

Thank you very much!!!!!
:-)

xxx.

Best Regards,
Joyce A. Recacho
São Paulo/SP
Brazil
Post Reply