× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. August 2004

iSeries Deleted Record Question

Folks,

 

I have a physical file that has five key fields and the keys must be unique.
There is also a check constraint on the file that in essence will not allow
a NULL value in the 5 key fields.   The file in question is also set to
reuse deleted records=*YES.

 

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.  

 

Running OS/400 V5R2M0 with CUME 4077520, HIPER Lvl 108, and DB2 Lvl 15.

 

Thanks!

 

Mike Shaw

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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