Midrange News for the IBM i Community

Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
Physical file - Record types in a certain order???
has no ratings.
Published: 21 Sep 2012
Revised: 23 Jan 2013 - 3448 days ago
Last viewed on: 28 Jun 2022 (4721 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Physical file - Record types in a certain order??? Published by: Chris Proctor on 21 Sep 2012 view comments(4)

I don't believe there is a way to do this, but I thought I'd run it by all you gurus anyway. Wink

I have a really strange problem where the program is writing 3 records to a control file, one right after the other with type codes I, T, and G. The key to the control file is vendor, PO# and backorder#, so these records should stay in the order written. Well, occassionally for no reason that I can deduce, they get out of order.

I was wondering if there is anyway in the file definition that I can say that they have to be in I, T, and G order? If not, can anyone think of any way these could randomly get switched.

What's weird is that we reran the same PO thru again with the same results. It just makes no sense. A way of ordering the record types would be the ideal solution.



Return to midrangenews.com home page.
Sort Ascend | Descend