Re: CPF5009 - Duplicate record key in member

I stand corrected!!!!
It IS because of the reuse deleted records!
I had to create two deleted records so that I wasn't reusing the first
row. The new first row was a key not used by the program. The second key
was a key used. I deleted them. First add was ok. Second add failed, in
an attempt to resurrect the dead. Details as follows:

delete from rob.lim

delete from rob.lim

1 rows deleted from LIM in ROB.

INSERT INTO ROB.LIM VALUES('B')

1 rows inserted in LIM in ROB.

INSERT INTO ROB.LIM VALUES('A')

1 rows inserted in LIM in ROB.

delete from rob.lim

2 rows deleted from LIM in ROB.

CALL LIMRPGLE

Last File Statement . . . . . . . . . : 00000007


Message ID . . . . . . : CPF5009 Severity . . . . . . . : 10
Message type . . . . . : Diagnostic
Date sent . . . . . . : 01/24/08 Time sent . . . . . . : 15:26:47


Message . . . . : Duplicate record key in member LIM.
Cause . . . . . : The output or update operation to member number 1
record
number 2 format LIMR, for member LIM file LIM in library ROB, failed.
Membe
number 1 record number 1 format LIMR has the same record key as member
number 1 record number 2 format LIMR. 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.

Rob Berendt