|
Maibe this is what you are looking for?... Position 28 (Limits Processing) Entry Explanation L Sequential-within-limits processing by a record-address file Blank Sequential or random processing Use position 28 to indicate whether the file is processed by a record-address file that contains limits records. A record-address file used for limits processing contains records that consist of upper and lower limits. Each record contains a set of limits that consists of the lowest record key and the highest record key from the segment of the file to be processed. Limits processing can be used for keyed files specified as primary, secondary, or full procedural files. The L entry in position 28 is valid only if the file is processed by a record-address file containing limits records. Random and sequential processing of files is implied by a combination of positions 18 and 34 of the file description specifications, and by the calculation operation specified. The operation codes "SETLL (Set Lower Limit)" on page 697 and "SETGT (Set Greater Than)" on page 693 can be used to position a file; however, the use of these operation codes does not require an L in this position. For more information on limits processing, refer to the ILE RPG Programmer's Guide. Chapter 14. File Description Specifications 261 Haas, Matt wrote:
If you're using embedded SQL, yes. If you're doing traditional file I/O, you'll need do a SETLL and then check to make sure you're within the range after each read. Matt -----Original Message----- From: Chuck Lewis [mailto:clewis@iquest.net] Sent: Tuesday, October 15, 2002 2:13 PM To: RPG400-L Subject: Specifying Check for Range in ILE RPG ? Hi Folks, Tried finding this in the online manuals with no luck. I could have overlooked it since I am not positive what it would be called (didn't see it in the Op Codes section of ILE RPG for AS/400 Reference). I need to check for records matching a range in an RPG program. I have done this in a CL and also with OPNQRYF but in this case would rather do it in an RPG program. I am loading a work file with information to create "Bin Labels". A user requests Bin Labels in a range of Row/Bin/Shelf. Each of these 3 fields is 3A. They will specify a starting and ending number. For example they request labels for B2E 1A2 F99 to B2E 5B6 F99. How do I handle this in ILE RPG, i.e. is there a %RANGE expression ? Thanks in advance ! Chuck _______________________________________________ This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l or email: RPG400-L-request@midrange.com 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@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l or email: RPG400-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.
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.