|
I don't want the previous record, but let's just say that, in my example, I know that the customer's record is greater than 95, but I don't know exactly which value (it's a timestamp, and I only have the date). By SETLLing to 96, with the values in this file, will I be positioned to just before the 96 record? BTW -- If the key wasn't descending, I know how it all works -- I am just not sure how SETLL is affected by DESCEND. On 10/24/05, PHarte@xxxxxxxxxx <PHarte@xxxxxxxxxx> wrote: > > If you want to read the previous, would you just just SETLL and READP? > Similar to SETLL and READE. > > > > > > > Tony Carolla <carolla@xxxxxxxxx> > Sent by: rpg400-l-bounces@xxxxxxxxxxxx > 2005/10/24 03:05 PM > Please respond to > RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx> > > > To > RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx> > cc > > Subject > SetLL And DESCEND > > > > > > > I have a file that is keyed descending, i.e. > > Key CustID > 99 AA100 > 96 CJ450 > 92 XC344 > 36 ZX908 > > If I want to start reading at key 96, will > > SETLL 96 FmtName; > > Position the cursor just before key 96? What if I want to position the > cursor one key previous to the customer. Would > > SETLL 97 FmtName; > > Position the cursor just before key 96, in this case? I have never used > SetLL with a DESCENDing key... HELP! > > -- > "Enter any 11-digit prime number to continue..." > "In Hebrew SQL, how do you use right() and left()?..." - Random Thought > "If all you have is a hammer, all your problems begin to look like nails" > -- > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list > To post a message email: RPG400-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l > or email: RPG400-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/rpg400-l. > > > -- > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list > To post a message email: RPG400-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l > or email: RPG400-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/rpg400-l. > > -- "Enter any 11-digit prime number to continue..." "In Hebrew SQL, how do you use right() and left()?..." - Random Thought "If all you have is a hammer, all your problems begin to look like nails"
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.