Table of Contents
Ispirer Website
Ispirer Capabilities - Informix Migration
Free Trial
Informix Dynamic Server (IDS) - Error Messages
This article describes the frequently-used error messages and codes in Informix Dynamic Server (IDS) 11.50 and earlier.
-239 Could not insert row - duplicate value in UNIQUE INDEX
The row that is being inserted or updated contains a duplicate value of some columns on which an unique constrains is defined. Returned for repeatable read isolation, see also Error -268
-242 Could not open database table
The table could not be accessed due to various reasons - file permissions, hardware errors, corrupted system catalog etc.
-268 Unique constraint violated
The row that is being inserted or updated contains a duplicate value of some columns on which an unique constrains is defined. For repeatable read isolation, Error -239 will be returned instead of -268.
-271 Could not insert new row into the table
Could not insert a row due to various reasons - disk full, locked table etc.
-691 Missing key in referenced table for referential constraint
A referential constraint has been violated during SQL INSERT operation on a child table that does not match a key in the parent table.
-692 Key value for constraint constraint-name is still being referenced
A referential constraint has been violated during SQL DELETE operation on a parent table that referenced by a child table.