How to delete a record and its index entries using IDXFIX?

How to delete one record and its index entries with IDXFIX?
How to delete a duplicate record when the ABL/4GL will not allow access to the duplicate record with a unique index?
How to delete a duplicate record with a unique index violation?
How to delete a record and all its index entries for the record?

Use the PROUTIL IDXFIX utility to delete one RECID and all its index entries:

• This operation can be performed while the database is online or offline
• Clients that have the record in their buffers may get errors once the record is deleted
• When this IDXFIX Option "Delete one record and it's index entries"  is used, the database engine does not execute the actions configured for delete triggers
• It deletes one record and all its index entries from the database without checking integrity.
• Before running IDXFIX to delete the record content it is advisable to first export what content of the record can be found and to assure a valid database backup.

Command syntax:  proutil <dbname> -C idxfix

Steps: 

1. Choose IDXFIX Option 6 Delete one record and it's index entries
2. Enter the RECID number of the record to delete.  This is known from specific index error messages that necessitate deleting the record.
3. Enter the Area Name or Number where the table's record is physically stored. For versions prior OpenEdge 10.1C the Area Number must be entered. Refer to Article PROUTIL -C IDXFIX Option 6 errors when Storage Area Name is entered  
4. A prompt to confirm that the information supplied is correct.
5. Enter Y and the RECID and all its index entries will be deleted.

When there are many records to be deleted, the following Article outlines methods to script IDXFIX:6

• How to automate removal of duplicate records detected by IDXBUILD error 1127  

Other methods are outlined in Article Fixing 1127 messages after an IDXBUILD   


 

Progress Articles:

IDXFIX 6 does not error on deleting a template record