Informix Error Messages and Error Codes From Error 4148 to 4155


Informix Error Code -4148 CHAR (*) type is not allowed in SQL statements.
The CHAR(*) type is not allowed as an SQL type. It cannot be used in CREATE TABLE, ALTER TABLE, and so on.
Informix Error Code -4149 Expressions of this type are not allowed in SQL statements.
An identifier that is mentioned in an SQL statement is of a type such as FOREIGN, or it names an object (a member of a class) or a record.
Informix Error Code -4150 First parameter must be an ixRow object.
For calls to the built-in functions packrow() and unpackrow(), the first argument must be of type ixRow.

Informix Error Code -4151 Constructor cannot be called directly.
A constructor cannot be called directly using the CALL statement or as the function in a function call expression. The constructor should be invoked indirectly using the NEW operator.
Informix Error Code -4152 Invalid begin or end name for THROUGH expression.
Invalid expressions have been used in a THROUGH expression in an SQL statement.

Informix Error Code -4153 Warning: The constant expression with the USING clause has been evaluated based on the values of the environment variables at compile time.
This warning is generated when a value for a CONSTANT contains a USING clause. The settings for environment variables DBFORMAT and DBMONEY can affect the result of the USING operation. This warning reminds the user that the USING clause in the CONSTANT statement will be evaluated at compile time and might not be consistent with other USING clauses that are evaluated at runtime.
Informix Error Code -4154 The maximum size allowed for a constant of type CHAR or VARCHAR is 255.
In a CONSTANT declaration or definition, the size of a character type constant (CHAR or VARCHAR) cannot exceed 255.
Informix Error Code -4155 Warning: Only static cursor names are allowed in the WHERE CURRENT OF clause. Cursor name will be processed as a static cursor name.
In the UPDATE and DELETE statements, the WHERE CURRENT OF cursor-name clause cannot cite a cursor name that has been declared as dynamic.

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 *