In this blog post, let’s learn about the error message “127 ISAM error: no primary key.” in Hydra and the description of the error.
Error Message
127 ISAM error: no primary key.
Error Details
The ISAM processor was asked to retrieve a row by its physical location but could not find a row at that location.
For C-ISAM programs, if you are using access by record number, review the number stored in isrecnum; it is invalid. Otherwise, the current index might be damaged; run the bcheck or secheck utility.
For SQL products, the index has been damaged. Run the oncheck utility to check and repair the index if you are using Informix Dynamic Server, INFORMIX-Universal Server, or INFORMIX-OnLine Dynamic Server. Run bcheck or secheck if you are using the INFORMIX-SE database server. Run tbcheck if you are using the INFORMIX-OnLine database server.