Re: SQL help

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

Just thinking - for once <g>

In the old days we did not have unique constraints that could be attached
to the physical, did not have even a primary key (which is unique). So this
vulnerability existed all over the place.

Even today, how many of us put all the unique indexes on a physical as a
unique constraint? Isn't that what we'd need to do, in order to be
completely safe from this vulmerabilty?

At 10:04 AM 4/24/02 -0400, you wrote:


>John,
>
>Couldn't agree with you more.  I could never figure out why Sears so
>heavily promoted NOT having your PF's keyed and depending on the LF's for
>your keys...back in the old days...:)
>
>I always key them where I can....even if it's not unique.  You never know
>when you're going to need to use something like WRKDBF or DBU on a file
>and need a nice, quick easy way to hit the desired records...
>
>Don in DC
>
>----
>
>On Tue, 23 Apr 2002 jpcarr@tredegar.com wrote:
>
> >
> > >Is this a bug?
> > >Just one more reason why I like keys on my physical files.
> > >Rob Berendt
> >
> > I couldn't agree more Rob.   Just for the reason you showed.   If your
> > unique Key is on a LF instead of on the PHY, You will have exposure of
> > dups.
> >
> > My UNIQUE's have always been on the PHY.
> > (No I don't want to hear of Damaged Objects..... - After 15 years,  never
> > had one)
> >
> > John
> >
> > _______________________________________________
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> > To post a message email: MIDRANGE-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> > or email: MIDRANGE-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.