Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Informix Request SQLWays

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.


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Informix Request SQLWays

sqlways/informix/error-messages.txt · Last modified: March 20, 2013, 03:54:41 AM (external edit)
 
Ispirer Ispirer © 1999-2014, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement