Informix Error Messages and Error Codes From Error 356 to 362


Informix Error Code -356 Data type of the referencing and referenced columns do not match.
The data types of the columns in the child constraint must be identical to those in the parent constraint.
Informix Error Code -357 Dependent table for view view-name has been altered.
The view is based on data from a table that has been altered since the view was defined. The alteration removed or renamed a column that is used in the view. The view can no longer be used. Drop the view, and redefine it to use the current schema.

Informix Error Code -358 Must close current database before CREATE, START or ROLLFORWARD.
These statements choose a new current database, but the present database must be closed first. Use the CLOSE DATABASE statement before this statement.
Informix Error Code -359 Cannot drop current database.
The database that is currently open cannot be dropped. First use the CLOSE DATABASE statement; then you can drop it.
Informix Error Code -360 Cannot modify table or view used in subquery.
The UPDATE, INSERT, or DELETE statement uses data taken from the same table in a subquery. This action is not allowed because of the danger of getting into an endless loop. Select the input data into a temporary table first, and then refer to the temporary table in the UPDATE or INSERT statement.

Informix Error Code -361 Column size too large.
This internal error reflects a communications problem between the database server and the application. You should not see this error. If the error recurs, please note all circumstances and contact Informix Technical Support.
Informix Error Code -362 Can have only one column of serial/serial8 type.
A table can have at most only one column of type SERIAL and one column of type SERIAL8. You are attempting to add a second column of type SERIAL or SERIAL8, or you are attempting to create a table with more than one column of either type. If you intended to have a foreign key (that is, a column that refers to a SERIAL or SERIAL8 column in a different table), the data type of the column in this table should be INTEGER or INTEGER8.

Above are list of Informix Error Messages and Errors Codes or Status Codes or Exit Codes along with Error and Warning messages received while performing certain operation against Informix applications or related products.

What are Informix Error Messages?
All Informix messages returned by the Informix server are assigned an error code.

In general, each Informix error contains the following information:
• The Informix Error Code or Informix Error status
• The message text. This text is usually returned with the Error code. Some messages employ word substitution, where the word substituted represents the system-replacement of a term more specific to the occurrence.
• An explanation of how the error may have occurred.

Hope this was helpful.

SQLServerF1 Team
Information about Informix Error Codes or Status Codes or Exit Codes and Error Messages on Windows, Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *