MVSFORUMS.com

[hope_wx]

Hi All

Any one have idea how read prev/next work for dup alternative index.

When i test my pgm, it seems that it always read all the dup alternative index from top to end and then process the next or previous alternative index.

Example:

Alternative index Primary key
AAA 4
BBB 1
BBB 2
BBB 3
CCC 7

Now i use BBB to startbr Alternative index, no matter readnext or readprev three times, i always get 1 / 2 / 3 record

[Dibakar]

Maybe by now you already know the reason, else check this link -
The order in which records with duplicate alternate keys are returned is the order in which they were written to the data set. This is true whether you are using a READNEXT or a READPREV command. For this reason, you cannot retrieve records with the same alternate key in reverse order.