RE: DDS Support

["John Taylor" <john.taylor@xxxxxxxxxxxxxxx>]

> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of James W. Kilgore
> Sent: Friday, June 30, 2000 2:37 AM
> To: MIDRANGE-L@midrange.com
> Subject: Re: DDS Support
>
>
< big snip >

> Within this thread, Eric N. Wilson posted what may be a workable
> solution to the REFFLD issue.  My problem has not been with the use of
> SQL as an alternative to CHAIN, but in the definition of the file
> itself.  As I understand it, referential integrity can only be
> implemented on those files that are created via SQL.  RI is my goal, but
> I didn't want to trade one benefit (RI) at the cost of another (REFFLD).


James,

I'm sure that you probably already know this, but your statement may lead to
confusion for some, so I thought that I'd better clarify. Referential
integrity can be applied against any PF on the AS/400, whether created by
SQL or DDS. There are a set of commands that allow you to maintain physical
file constraints. These commands are ADDPFCST, RMVPFCST, CHGPFCST, WRKPFCST.


Regards,


John Taylor
Canada


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---