RE: [MI400] change collating sequence

["Harry Williams" <planesmart@xxxxxxxxxxxx>]

For resorting the file, I have used  OPNQRYF, which is driven by the QQQUERY
program, or SQL. So not to force a recreation of the Index, I create logical
files with the Index I need. 

Personally, I don't think you can change the sorting by just changing the
sort sequence. Though indexing is fun and neat, it still has to be able to
find the key quickly, last time I was calculating it on the 400, it appeared
to find its record in 1.4 tries.  From what I understand how the index works
is to be "sorted" in a way that it can be found physically. Kind of like the
old Hi Low game.  It looks physically at the middle of the index, if it
needs higher it goes to the middle of the file of the divided piece. This
high low method will get you to the record in 7 tries. But you physically
have to have the records in a sequence to do this. I know with B+ triev,
they had an access of about 3.5 tries, where IBM reached 1.4 tries. Query
and SQL can't do it, you see the indexing or sorting working when a keyed
path cannot be found. 

If someone has an answer other than this, I will be very excited. 
Harry 









-----Original Message-----
From: mi400-bounces+planesmart=teleteam.net@xxxxxxxxxxxx
[mailto:mi400-bounces+planesmart=teleteam.net@xxxxxxxxxxxx] On Behalf Of
Raikov, Leonid
Sent: Friday, August 06, 2004 5:03 AM
To: 'mi400@xxxxxxxxxxxx'
Subject: [MI400] change collating sequence

Is anybody aware of a way to change the sorting sequence for a logical
without recompiling the DDS? I tried changing the sorting table in the
primary space and forcing the access path recreation, but it does not
seem to be working.

Lo
_______________________________________________
This is the MI Programming on the AS400 / iSeries (MI400) mailing list
To post a message email: MI400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mi400
or email: MI400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mi400.