Re: RPG Cycle

[Jim Langston <jlangston@xxxxxxxxxxxxxxxx>]

It all depends on why they were orphaned.  Was a header record deleted
on accident, and you need to find it?  In some cases I had to go to an old
backup and find the header records and copy them over.

Where they part of a transaction that wasn't completely added because of a
system crash?  In some cases, I delete them.

Where they part of a transaction that is "missing", and no one can find the
header record?  In some cases, I recreate the header record the best I can.

Does no body know why they're there?  In some cases I move them to an
archive file and forget about them, 'til someone asks about one of the records.

Where they left over from a badly written archive program?  Then I move them
to their archive file where they belong.

Orphans are a very bad thing, and should not happen.  But Murphy's law does
prevail, we just have to be the ones to clean up behind Murphy's messes.

Regards,

Jim Langston

"James W. Kilgore" wrote:

> Hi,
>
> I've got to ask.  Once the system shows you the orphans, what do you do about
> them?
>
> If the referential integrity checker doesn't allow them, how do you get rid of
> them?

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