× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



On Sun, 2005-04-03 at 11:00, Vernon Hamberg wrote:
> This is really in response to later posts.
> 
> Just tried a couple things - found a way to apply an index to a PF that was 
> in an LF, assuming there was no key on the PF originally. And not using CHGPF.
> 
> 1, ADDPFCST using the key of the unique LF
> 2. RMVPFCST and take the 'K' response - to keep the key. Now the PF is 
> keyed and has no primary key.
> 
> Oy! I guess I have too much time!

you said it... not me... <VBG>

now... for yucks... what happens in save/restore of that change?


> 
> Vern
> 
> At 07:17 AM 4/3/2005, you wrote:
> >True. I may not have been precise enough in my language there. My fault.
> >
> >Generally in dealing with iSeries shops, when they say primary key, they
> >aren't usually refering to a "real" SQL DDL primary key constraint, but
> >either a logical file's or the physical file's key specification that
> >they consider to be primary.
-- 
"Bigamy is having one wife too many. Monogamy is the same."
-- Oscar Wilde


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.