Re: copy failure

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Delete the record with the duplicate key before you perform the copy,
temporarily remove the unique key constraint, in which case you will end
up with non-unique keys, or if that really doesn't matter, remove the
constraint permanently, or allow cpyf to skip the insert by setting the
number of allowable errors to *NOMAX. Cpyf is probably not the best way
to handle an update that needs record level logic. It would be fairly
straight-forward with SQL.

Pete Hall
pbhall@xxxxxxxxxxxxx
http://pbhall.us


donna lester wrote:

I am doing a copy in one of the jobs, it fails for the reason below:
Below is the joblog:
Can some one let me know how to make sure copy successful?
-----------------------------
CPYF FROMFILE(dlester/CHIFMTSBK) 
TOFILE(GMSPROD/CHIFMTS) MBROPT(*ADD) 
Message . . . . : Key for record in member CHIFMTS reserved. 
Cause . . . . . : The output or update operation on member CHIFMTS, file 
CHIFMTS in library GMSPROD, record 0 format CHIFMTS member number 1 was 
not successful. Format CHIFMTS member number 1 is under commitment control 
and has the key reserved. If the record number is zero, the duplicate key 
occurred on an output operation. 
30 01/10/07 14:09:09.785632 QDBSIGEX QSYS 01D6 QCPGENIO QSYS 
Message . . . . : Duplicate key on access path for based-on member of 
CHIFMTS. 
Cause . . . . . : An output or update operation on record number 0 record 
format CHIFMTS member number 1 failed because of a duplicate key in a unique 
keyed member that is based on member CHIFMTS file CHIFMTS in library 
GMSPROD, or in a based-on member of CHIFMTS. The key is a duplicate of a 
reserved key under commitment control. Recovery . . . : See previously 
listed message CPD4068 to identify the record with the duplicate key and 
change the key value so that it is unique. Then try your request again. 
Message . . . . : Cancel reply received for message CPF5085. 
Message . . . . : Error writing to member CHIFMTS in file CHIFMTS. 
Cause . . . . . : The file was not copied because an error occurred while 
writing records to member CHIFMTS in file CHIFMTS in library GMSPROD.
   
  Regards
  Donna

 
---------------------------------
Have a burning question? Go to Yahoo! Answers and get answers from real 
people who know.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFpaNnpcZsDl8OX6kRAqDFAKCb9C7hUpd3MOvLkIFlUIcNSiJF1gCcDaqF
aejKKqWAz0U+eUPliPwbAc4=
=e1rd
-----END PGP SIGNATURE-----