Re: Removing constraints

[R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

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