Use account name option in Hashfile stage

[shah.tejasvi.p]

Hi,

I have a job that writes data into a hashfile.
When I look into the hashfile stage, the use account name option is used and the file name in the input stage is a job parameter.
I can view the contents of the hashfile using view data option but where can I actually find this file?

Thanks for all your help in advance.

[Klaus Schaefer]

Hello Shah,

be aware that a hash file is a UNIVERSE table - not readable/editable with a simple text file editor. It can be found in the project folder specified in the account name option. If the account name field is left empty (which usually is the case) the hash file ist created in your current project folder.

Klaus

[asorrell]

For example, on Windows at release 7, if your software is installed on the server at E:\Ascential\DataStage, then the file you are looking for would be in E:\Ascential\DataStage\Projects\ProjectName\Filename.

I would also not recommend modifying or moving the file at the O/S level. DataStage has internal pointers that keep track of the file.