On Thu, 17 Oct 1996 17:14:06 -0700, Bill Carneal <[log in to unmask]>:
>
>Greetings, Listers!
>
>I have a flat file (>56,000 recs.) with account # in columns 1-8 and
>2-digit suffix #s in columns 10-11, sorted in ascending order.  If an
>account has more than one suffix associated with it, a record exists for
>each suffix (with the same account # in columns 1-8).  An account might
>have only one record, or multiple records.
>
>Our auditors want a report that shows the first account and all the
>records with that account #.  Then the report needs to show every 22nd
>account thereafter (with all records for that account#).
>
>What would be the best way to generate such an extraction from the
>flat file?  We have the standard MPE/iX tools, as well as MPEX and
>SpeedWare's EasyReporter.
>
>We are on MPE/iX 5.0 Express 3.  The file has 132 byte records.
>
>Thanks in advance for any suggestions!
>
>Bill Carneal
>CCCU - Las Vegas

Bill,

I think it's going to be really difficult to generate a report like you want
without writing any code.  I'm not real familiar with EasyReporter, but if it
supports flat files then using it to create the report would be the way to go.
Otherwise, looks like a job for COBOL (or C or RPG or . . .).

Jim Phillips                            Manager of Information Systems
E-Mail: [log in to unmask]      Therm-O-Link, Inc.
Phone: (330) 527-2124                   P. O. Box 285
  Fax: (330) 527-2123                   Garrettsville, Ohio  44231