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
Hash File Sort
Moderators: chulett, rschirm, roy
Hash File Sort
from SPA_BI
hi
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.