Re: RPG Cycle

[pcunnane@xxxxxxxxxxxxxx]

     Hmm.  Sounds like something I would tackle with a SQL 'WHERE x NOT IN' 
     subquery.
     
     ____________
     Paul Cunnane


______________________________ Reply Separator _________________________________
Subject: Re: RPG Cycle
Author:  fkolmann@revlon.com.au at InterNet
Date:    2000-02-18 9:45 am


Anyhow recently I had this case,
Order Header File (Keyed by Order number)
Order Detail File  (Keyed by Order Number,  Line Number) 
Invoice Detail File (Keyed by Order Number , Line Number) 
I asked a programmer to use Control breaks and MR to find
mismatched Headers and also mismatches between the Order Lines and Invoice 
Lines,
we had a problem using MR to find orphaned Invoice Detail Lines, we had to write
2
programs
the first using the Header as a primary file, the second used the Detail as the 
Primary file.
Perhaps you have a suggestion how we can do this with one program.
     
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---