Re: CPF5009 - Duplicate record key in member

It says the following -

If the record number is zero, the duplicate record key occurred on an output operation.
Recovery . . . : Change either record key so that the keys are unique.
Then try your request again.

Lim, what it doesn't say is - if the record number is not zero, then this is NOT an OUTPUT operation.

But it is interesting, and could well be related to REUSEDLT(*YES).

Rob,

You said that once the record was deleted, it does not have a RRN. Is that true? I thought that the byte that defines the record as deleted was set so that the DB no longer sees it. But it's still in the file, and can be recovered. And can it's RRN be used if REUSEDLT(*NO) is set?

Just curious...

Crispin.

Okay Lim
why are you EXPECTING the text to say "record number 0"?



Alan Shore
I don't think I explain my question correctly.

It is correct that the system is given me a duplicate key error. I'm
not questioning the system giving such an error. I'm question about the
CPF message TEXT. In the TEXT it said:
"The output or update operation to member number 1 record number 1377
format ORDETR, for member ORDET file ORDET in library APLUS2FMC,
failed."

For a WRITE statement I do not except it to tell me the record number
1377. The TEXT should be
"The output or update operation to member number 1 record number 0
format ORDETR, for member ORDET file ORDET in library APLUS2FMC,
failed."

Clear as mud?