Re: CPF5009 - Duplicate record key in member

Rob,

Sorry, read more into something than was there. But please also see my tests and what happened for me...

Crispin.

----- Original Message ----- From: <rob@xxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Thursday, January 24, 2008 3:23 PM
Subject: Re: CPF5009 - Duplicate record key in member

I said nothing about a RRN. I said the key is not tied up anymore. See
the sample I sent.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Crispin Bates" <cbates@xxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
01/24/2008 03:06 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
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?

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.