Re: iSeries Deleted Record Question

[Simon Coulter <shc@xxxxxxxxxxxxxxxxx>]

On 31/08/2004, at 6:36 AM, Mike wrote:

> My question is this:  Does a record that is deleted constitute a NULL 
> value
> in the file?  The file in question is showing 4 deleted records.  I 
> keep
> seeing a CPF5009 message (duplicate record key in member) in job logs 
> that
> touch this file.

No, a deleted record is deleted and no longer in any index.

Of course if your application doesn't really delete but flags records 
as deleted by setting some flag field to a magic value then the record 
still exists and will be in an index and could cause duplicates.

The same is true if your application tries to set the fields of deleted 
records to null either explicitly or via a constraint.

The message indicates that an application tried to add a new record 
with a key that matches an existing record, or tried to update the key 
fields of an existing record such that they match another existing 
record.

The second level text of the message tells you which records are the 
culprits so you can determine what the key values are by examining the 
existing record.

Regards,
Simon Coulter.
--------------------------------------------------------------------
   FlyByNight Software         AS/400 Technical Specialists

   http://www.flybynight.com.au/
   Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
   Fax:   +61 3 9419 0175                                   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------