Viewing Data in DataStage Hashed files

mdbatra · Post by **mdbatra** » Fri Oct 07, 2011 1:48 am

Hi All,
I have recently transitioned from DataStage EE to Server version.
While working with Hashed files here in server, keen to know how to view the data in Hashed files from Unix like we do for datasets in EE using orchadmin commands ? Tried in administrator client, listing the hashed file(direcotry) like DS_JOBS etc. but no luck. Is it that if i create the file using 'Account Name' property, then only i would be able to read it from Admin as it would create the file in Project Directory ? Not sure/tried.
I have searched a number of posts here as well but couldn't get the needed one.
Any help to view the metadata and data for hashed files from Unix/Admin Client , would be appreciated.
Thanks !

mdbatra · Post by **mdbatra** » Fri Oct 07, 2011 3:12 am

After little more search, i understand that we need to use the dssh command from the $DSHOME/bin. Do we need to execute dsenv here first and then execute dssh ?
I don't have permissions to execute dsenv, hence checking whether i am on correct lines or not . But i still couldn't figure out how to make a call from Admin client for Hashed files(created at external paths) ?

ray.wurlod · Post by **ray.wurlod** » Fri Oct 07, 2011 4:00 am

If the hashed file is account (project) based you use a query language - either DataStage SQL or RetrieVe.

If the hashed file is not account based you need to create a VOC pointer to it then use a query language.

Yes, you do need to have executed the dsenv script first.

mdbatra · Post by **mdbatra** » Wed Oct 12, 2011 7:43 am

Thanks Ray !