039

27

N

N

One of the following occurred:

• An attempt was made to add
  a record containing a value for
  a key designated as a Master
  Key which matches the Master
  Key value of another record
  in the table. The add is
  rejected because the table was defined to disallow duplicate Master Keys (DUP-MSTR-KEY attribute-value is N for no).

If the Master Key is also
specified as a unique key then
the duplicate decision is based
on committed data (that is, the
existing record is not subject to
transaction backout).

If the Master Key is not also
specified as a unique key, then
the duplicate decision is based
on the current conditions (that is,
the existing record may or may
not be subject to transaction
backout).

• A LOAD function attempted to load a record containing a value for a key designated as a Master Key with no duplicates allowed, or as a unique key. If the LOAD parameter LOADDUPS is specified as NO (the default value) the LOAD function fails with the return code 10.

To add a record containing a duplicate Master Key or unique key value:

• Delete the existing record before adding the new record to the table.
• Use CA Datacom Datadictionary to modify the definition of the table to allow duplicate Master Key values or the definition of the key so it is not a unique key and catalog the definitions before adding the new record.
• If loading the table, code LOADDUPS=YES in the DBUTLTY LOAD function statement.