Hashed file query from outside project

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
mujeebur
Participant
Posts: 46
Joined: Sun Mar 06, 2005 3:02 pm
Location: Philly,USA

Hashed file query from outside project

Post by mujeebur »

As a project standard , we stored all the hashed files outside the repository(project) directory. So there is no entry of this in VOC . But I would like to query the data and verify thru TCL ( DataStage/SQL ) .

Any work-around ?
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Search the forum for using SETFILE. However, be aware that this leaves a pointer in the project for that hash file. Sometime in the future you may relocate the hash file, and will need to update that pointer again.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Post Reply