DSXchange

Hi,

I have noticed records are not stored in a sorted order in a hash file.

Is it possible to have the records sorted... or at least maintain ordering inside the hash file?

thanks,

SPA_BI

Here is a nice link

I guess you have to post this in the server forum

Hi

We cannot do any sort operation in hash files only way is to use sort stage.If your src in ODBC stage then add ORDER by in your query.But you can apply any filter conditions in Hash file Stage: output->selection "here you can specify filter condition".

Thanks,
Rachitha.

It is not possible to prescribe storage order in a hashed file, for exactly the same reasons it is not possible to do so in a database table. The database controls where records are stored. In the case of hashed files, it's the hashing algorithm.

You can sort upon retrieval either by retreiving with an ORDER BY clause in a UniVerse stage, or with a BY clause in a Hashed File stage (on the Selection tab).

Of course, hashed files are principally used for key-based lookups, so the issue of sorting is moot.