Kbase P126036: How to delete a record and its index entries using idxfix?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/01/2011 |
|
Status: Verified
GOAL:
How to delete one record and its index entries with idxfix?
GOAL:
How to delete a duplicate record when the 4GL will not allow access to the duplicate record?
GOAL:
How to delete a duplicate record?
GOAL:
How to delete a record and all its index entries for the record?
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.1x
Progress 8.2x
Progress 8.3x
Progress 9.x
OpenEdge 10.x
FIX:
Use the idxfix options of proutil to delete one RECID and all its index entries.
Command syntax: proutil <dbname> -C idxfix
- Choose option 6 (Delete one index and it's index entries)
- Enter the RECID number of the record to delete.
- Enter the area number that the record is physically stored in.
You will then be asked to confirm that the information supplied is correct.
- Enter Y and the RECID and all its index entries will be deleted.