Page 1 of 1

Hashed file query from outside project

Posted: Tue Oct 04, 2005 3:23 pm
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 ?

Posted: Tue Oct 04, 2005 3:32 pm
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.