Let's keep it simple then. What sound business reason is there to not
have a primary key constraint on the item master file?
...especially when it can be easily added (created) with a ADDPFCST
command even if there is no key in the DDS.
I have a need from time to time to update a couple particular old
databases with a group of records that are supplied to me. The PFs
have no keys. The new records can be either updates of existing
records or additions of new records to the files. There are a number
of potential physical files to be updated, all of them with very
The simplest way for me to do it in _this_ case is to:
1. ADDPFCST to add a primary key.
2. CPYF using *UPDADD
3. RMVPFCST to drop the key that I added. (I'd gladly leave it in,
but there are some secondary issues.)
The only point is that it's such an easy process to add a primary
key that it's essentially trivial. It's almost as easy to remove the