MVSFORUMS.com

[issac1029]

Hi,

When I have duplicate key in alternateinde,that I must access all the relative records except by sequence?I want to get all the alter key ='1'

main alter
1 1
2 1
3 2
4 5
5 1
6 6
7 1

So when I 'read key is 'alter key'=1,I got the first record.If I want to retrivev the 2nd record then I can't use 'read key is' but use 'read next'.
1)If want to get the 4th then I must do 'read next' TWICE?
2)Can I use 'start (main)key is GE '3',then point the 3rd record,then 'read (alter)key is' ,this statement will scan begin at 3?Then I can fet the 5th record which I want.

[issac1029]

I've solve by test pgm using 'start key' and 'read next' to retrieve dup record ,no question now