Re: Referencial Integrity - Was: RPG Cycle

[boothm@xxxxxxxxxxxxxxxxx]

No. Don't write a program with matching records to find orphans.  It works 
great and runs like lightning, but the last time I did that the supervisor 
looked at the 10 lines of code and gave the project to a "real programmer" 
who did it in less than a day and less than 100 lines of code.
_______________________
Booth Martin
boothm@earth.goddard.edu
http://www.spy.net/~booth
_______________________




"James W. Kilgore" <qappdsn@attglobal.net>
Sent by: owner-rpg400-l@midrange.com
02/21/2000 10:54 AM
Please respond to RPG400-L

 
        To:     RPG400-L@midrange.com
        cc: 
        Subject:        Re: Referencial Integrity - Was: RPG Cycle


That brings back my original question, how to you clean the files?

Do you write a cycle program using NMR to delete orphans?

Raul Jager wrote:

> <<snip>>
>
> Once your files are clean, RI will prevent to delete a master record
> unlees you delete the detail firs, it will also prevente a detail record
> to be written if there is no master.  RI will also prevent to update the
> keys to a value that will leave orphans.
>

+---
| 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
+---




+---
| 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
+---