Ispirer Website
Ispirer Capabilities - Informix Migration
Free Trial
This article describes the frequently-used error messages and codes in Informix Dynamic Server (IDS) 11.50 and earlier.
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
The table could not be accessed due to various reasons - file permissions, hardware errors, corrupted system catalog etc.
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.
Could not insert a row due to various reasons - disk full, locked table etc.
A referential constraint has been violated during SQL INSERT operation on a child table that does not match a key in the parent table.
A referential constraint has been violated during SQL DELETE operation on a parent table that referenced by a child table.