RE: Reordering a file

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

Not here, Rob.  WRKPFCST on the file shows no constraints.  Since there
is no visible constraint, I cannot remove it.  RMVFCST *ALL returns
message CPD32B1 reason 12, which is "File has no constraints".

When I try to add *PRIKEY, I get message CPD3B24 reason 3, path is not
unique.  The help text tells me to add the constraint as *UNQCST.  I do
that and it works, but that's just a unique constraint.  I try once
again to add the primary key, but then I get message CPD3B20 reason 9,
unique constraint already exists.

Joe

> From: rob@xxxxxxxxx
> 
> Joe,
> Even though your primary key constraint was originally created with
your
> DDS, there's nothing from stopping you from RMVPFCST the original
> constraint, add a new constraint, sorting the file, removing the new
> constraint and adding the old one back with ADDPFCST.