RE: Reordering a file

Oh well, still grinding out our websphere install with the consultant - 
just my a$$ talking I guess...

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
11/19/2004 01:18 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: Reordering a file






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.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.