× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




You're on the right track Lim.

Frank





"Lim Hock-Chai" <Lim.Hock-Chai@xxxxxxxx>@midrange.com on 10/19/2004
03:13:55 PM

Please respond to RPG programming on the AS400 / iSeries
       <rpg400-l@xxxxxxxxxxxx>

Sent by:    rpg400-l-bounces@xxxxxxxxxxxx


To:    "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc:

Subject:    RE: Trivia: How many lines of code are allowed in an RPG
       Program?


I might be wrong here, but I think what he wants is to be able to
print/output by range.  Is like somebody ask you to print Serial Number by
range instead of detail and provide a count.

For example:

 From                 To
Serail Number     Serial Number  Total
AAAAAAA110        AAAAAAA125      16
AAAAAAA127        AAAAAAA128       2


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of fgarcia@xxxxxxxxxxxx
Sent: Tuesday, October 19, 2004 2:31 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Trivia: How many lines of code are allowed in an RPG
Program?



To group and range, try with something like this

declare XX cursor for SELECT city, MIN(zip_code), MAX(zip_code) * from
zip_input_file order by city, group by city.
open xx
fetch xx into :Vcity, Vmin, Vmax

dow sqlcode=*zero
     output file
     fetch xx into :Vcity, Vmin, Vmax
end

Fernando




As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.