Re: DES2K ERD - Transferable Relationships

"Transferable" determines if the resulting foreign key columns are updateable; this will be enforced on the client side only. You will see a similar property in your constraints dialog.

Allowing relationships in UIDs to be transferable is indeed a violation of the rules.

Robert Siegel <robertsiegel_at_compuserve.com> wrote:

>Does anyone know what are the downstream implications of whether a
>relationship is transferable. I cannot find anything in the
>documentation about this.
> The tool defaults to making all relationships transferable. It also
>indicates transferability on the parent end which does not make any
>sense to me because there will not be a foreign key column in the
>physical table to change the value of to make the transfer in the
>physical/real database table. The tool also seems to allow a
>relationship that is part of the unique ID to be transferable. That
>violates what I know about Oracle database tables that a primary key is
>not updatable.
> So what is the bottom line on all of this.

-JJ

Visit our new website at http://www.jeffreyjacobs.com

 Jeffrey Jacobs & Associates
 Oracle Designer/2000 Consulting & Training  951-2 Old Country Road, Suite 119, Belmont, CA 94002  Voice: 650-571-1457, FAX: 800-665-1379
 Email: jmjacobs_at_ix.netcom.com
 Web: http://www.jeffreyjacobs.com Received on Sat Nov 15 1997 - 00:00:00 CET