Informix Error Messages and Error Codes From Error 549 to 554

SQLServerF1

Informix Error Code -549 Column column-name in UNIQUE constraint is not a column in the table.
The column appears in the list of columns for a UNIQUE clause, but it is not one of the columns defined in this table. Check the spelling of all column names in this statement. If they are as you intend, then check the definition of the table. See the discussion of error Informix Error Code -328 for a way to list all column names in a table.
Database servers after Version 5.01 do not use this error message.
Informix Error Code -550 Total length of columns in constraint is too long.
The total size of all the columns listed in a UNIQUE, PRIMARY KEY, or FOREIGN KEY clause is limited. The limit depends on the database server in use, but all servers support a total of 120 bytes. The limit is the same as the restriction on the total size of all columns in a composite index. For additional information, see the CREATE TABLE statement in the Informix Guide to SQL: Syntax.

Informix Error Code -551 The constraint contains too many columns.
The total number of columns listed in a UNIQUE, PRIMARY KEY or FOREIGN KEY clause is limited. The limit depends on the database server in use, but all servers support eight columns. The limit is the same as the restriction on the number of columns in a composite index. For additional information, refer to the CREATE TABLE statement in the Informix Guide to SQL: Syntax.
Informix Error Code -552 Blob host variables are disallowed in multi-statement prepares.
This EXECUTE statement executes a prepared list of multiple statements. One or more of the host variables supplied for the ? placeholders in the list is a locator structure for a TEXT or BYTE value. This action is not allowed. Statements that refer to TEXT or BYTE variables may be prepared and executed, but they must be single statements, not part of a multistatement list.

Informix Error Code -553 Mkdbsdir not found in $INFORMIXDIR/bin. Consult your installation instructions.
An executable program, mkdbsdir, is used to create the initial contents of the database directory during a CREATE DATABASE statement. It is distributed with the database server and should be found in the bin subdirectory of the directory that the INFORMIXDIR environment variable names, but it was not. Check the setting of INFORMIXDIR, and then consult with the person who installed the software.
Informix Error Code -554 Syntax disallowed in this database server.
The database server that you are using does not support this statement or some clause in it. When a program starts, the database server in use is chosen based on the SQLEXEC environment variable (for database servers prior to Version 6.0). Several small differences in statement syntax exist between INFORMIX-SE and other Informix database servers. For example, INFORMIX -SE supports the IN ‘pathname’ clause of the CREATE TABLE statement while other Informix database servers support the IN dbspace clause instead.

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.

Thanks,
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 *