What does the following return?
Select count(*) from arlcu where cunano = ' 000117'
Do you by chance have the field name for the National Account instead of Customer Account?
By the way, you will count the last record twice because you increment the counters after the read without checking %eof.
Scott Mildenberger | Software Developer | Washington Corporations | 101 International Drive | Missoula, MT 59808 | Office: (406) 523-1536 | www.washcorp.com
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxx> On Behalf Of Thomas Burrows
Sent: Tuesday, October 23, 2018 11:54 AM
Subject: Re: Problem with reading a file that does have keys
Here is what I mean from top to bottom on the file.
Using DBU here are the first three variables or columns.
Key 1 is the first column A5 length. Key 2 is the second column A14 length
This mailing list archive is Copyright 1997-2020 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