MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

read prev/next alternative index(dup)

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management
View previous topic :: View next topic  
Author Message
hope_wx
Beginner


Joined: 23 Jul 2006
Posts: 8
Topics: 5

PostPosted: Thu Jun 18, 2009 9:28 am    Post subject: read prev/next alternative index(dup) Reply with quote

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
Back to top
View user's profile Send private message
Dibakar
Advanced


Joined: 02 Dec 2002
Posts: 699
Topics: 63
Location: USA

PostPosted: Thu Nov 19, 2009 12:01 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group