DSXchange

Hi !!!

If anyway to preserve order of rows in hashed file according the order they enter the hashed file ?

May be to use different type of hashed file ?

Thanks

i think you know that data in hash file is key to data mapping, so i think their can be no way to preserve order.

Short answer is 'no'. Longer answer involves including the record number as a data element and doing an SSELECT or 'sorted select' to bring them back out in the input order. Requires an account-based hashed file, from what I recall, however.

Long answer is also "no".
It's the hashing algorithm that governs on which page/group/frame any particular record resides.
As noted, the only way to get sorted data out is to sort those rows.