|
Frank, One way would be to write each of your 608,400 combinations into a data file, (in sequential order of course) then chain to the record and see if the record number is one more than the last one. ~~~~~~~~~~~~~~~~~~~~ Another way would be to only check one character at a time. First determine how many characters you need to check. i.e. Select; When zip1.first5chars = zip2.first5chars; charsToCheck = 6; When zip1.first4chars = zip2.first4chars; CharsToCheck = 5; Ect EndSelect; Exsr Check Chars; BegSR Chars; For I = CharsToCheck to 6; // perhaps you know, but since I don't I have to check to see if this // is a numeric column or character. // then do a lookup on the zip1 column and the zip2 column. If result2 - result1 = 1 // see footnote* Do your processing; Else; Not in order; EndIf; EndFor; EndSr; * I was going to say that you'd have to check for a change from 9 to 0 or from Z to A, but now that I think about it, whenever that happens, in order for it to be in sequence there should have been a change in the previous column. You should only have to actually check one column for in-sequence. Every following column should be a rollover (9-0 or Z-A) and if it isn't, then the records aren't in sequence. Unless, of course, some zip codes are skipped. ~~~~~~~~~~~~~~ Duane Johnson Information Technology Services Programming Manager Coleman Powermate Inc. 4970 Airport Rd. Kearney, NE 68847 djohnson@xxxxxxxxxxxxx -----Original Message----- From: fkany@xxxxxxxxxxxxxxxxxx [mailto:fkany@xxxxxxxxxxxxxxxxxx] Sent: Tuesday, October 19, 2004 1:12 PM To: CN=RPG programming on the AS400/O=iSeries Subject: RE: Trivia: How many lines of code are allowed in an RPG Program?
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.