Query editor in hashed file

paddu · Post by **paddu** » Wed Feb 13, 2008 6:06 pm

Can we have flexibility to query hashed file in Stage itself in future . I know we can use UV stage but i am thinking it would be good to have editor option in the hashed file stage itself .

Something like this will really help for QA purpose .Easy to search combination keys or simply like sql editior quering a table ???

Am i too greedy

May be i think it is possible to query hashed file directly in version 8.0.1 , where we can choose the repository database to be oracle or DB2 ????

am i thinking right?

Please correct me .

ray.wurlod · Post by **ray.wurlod** » Wed Feb 13, 2008 6:20 pm

What it is you think you can't do? Is it a query builder, or the ability to view the data in the hashed file? Certainly you can do the latter with the data browser.

paddu · Post by **paddu** » Wed Feb 13, 2008 6:55 pm

I was looking for ability to view data in hashed file . Data browser in the hashed file has option like FIND.

Can we give multiple conditions on multiple columns in the FIND to hit on specific record????

kcbland · Post by **kcbland** » Wed Feb 13, 2008 8:58 pm

Look at using the dssh/uvsh command line. You have full SQL capabilities (as long as you have used setfile to deal with externally pathed files. You also have native Retrieve language capabilities (similar to SQL, specific to Universe/DSEngine).

ray.wurlod · Post by **ray.wurlod** » Wed Feb 13, 2008 10:01 pm

Or you can use the Administrator client Command window. DataStage/SQL is one of the two query languages available. Or you can use the RetrieVe query language, as Ken suggested. To view the table definition of a hashed file the command is LIST.DICT (for which you will also need a VOC pointer to the hashed file).

paddu · Post by **paddu** » Thu Feb 14, 2008 6:14 pm

Thank you both .

Will explore on the options you suggested.