Re: SQL help

[Don <dr2@xxxxxxxxxxxx>]

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