hi all,
i am getting below error when running a utility.This utility deletes record from table.
system error: index <index name> in <table name > for recid <recid> could not be deleted. (1422)
the index is neither a unique nor a primary. I can disp and update the same record using commands.
but only deletion gives me this error.
Please tell me why this occuring and how i can overcome this situvation.
only one record exist with this recid
this error message is written when attempting to delete a record and its associated index entries and the index entry for the specified index does not exist for some reason (it should be there).
You might be able to delete the record by using the IDXFIX database utility program.
Is the table for a temp-table or a database table?
for database table..
And i done idxfix, and this is resolved