Page 1 of 1

Viewing Data in DataStage Hashed files

Posted: Fri Oct 07, 2011 1:48 am
by mdbatra
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 !

Posted: Fri Oct 07, 2011 3:12 am
by mdbatra
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) ?

Posted: Fri Oct 07, 2011 4:00 am
by ray.wurlod
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.

Posted: Wed Oct 12, 2011 7:43 am
by mdbatra
Thanks Ray !