Re: RPG Cycle

["Nelson C. Smith" <ncsmith@xxxxxxxx>]

No exceptions allowed on referential constraints.  Either it's an orphan or
it ain't.  You gotta fix 'em before you can put the constraint on.  The
original request, though, was just to get a list of the orphans and the
system will provide that for you as a by-product of just trying to put them
on.  Once you got the list of orphans, you can forget the constraint.

Unless your files have a valid relational data set and no orphans.  In that
case, the constraint will go on and no list will be produced.  ;-)

----- Original Message -----
From: "Joep Beckeringh" <joep@beckeringh.myweb.nl>
To: <RPG400-L@midrange.com>
Sent: Friday, February 18, 2000 4:32 PM
Subject: Re: RPG Cycle


> > Try adding Referential Constraints to those files and the system will
show
> > you the orphans real quick.  No programming required.
>
> Except for the bit where you handle the data base exceptions :-)
>
> Joep Beckeringh
>
>
> +---
> | 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
+---