Off the top of my head, You could try *UPDADD instead of *ADD.....
   just press F1 for that field on the CPYF command to see details......

   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.
  

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 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.