|
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.
As an Amazon Associate we earn from qualifying purchases.
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.