Informix Error Messages and Error Codes From Error 2017 to 2023


Informix Error Code -2017 The character data value does not convert correctly to the field type.
You have entered a character value (a quoted string) into a field that has a different data type (for example INTEGER). However, the characters that you entered cannot be converted to the type of the field. Consult the operating instructions for this application, then reenter the data.
Informix Error Code -2018 A grammatical error has been found on line line, character column. The construct is not understandable in its context.
This message points to the exact spot in a source file where the compiler could no longer understand the input. The actual mistake might be earlier in the file, perhaps several lines earlier, but it is not later. Other, more specific error messages should also appear.

Informix Error Code -2019 This integer exceeds the maximum size allowed.
The INTEGER data type can accept numbers with absolute values from 0 to 2,147,483,647 (plus or minus (2 to the 31st power) – 1). If you have to store numbers outside this range, redefine the column or variable to use DECIMAL data type. (The value -2,147,483,648 is a 32-bit value but is not acceptable; it is used in 4GL to indicate a null value.)
Informix Error Code -2020 The table table-name could not be opened. The operating system was asked to open it for writing.
You are using a database server that manages tables as ordinary disk files. The current database is managed as a directory, and tables are files within it. Look for operating-system error messages that might give more information. Locate the database directory (either in the current directory or on a path that is named in the DBPATH environment variable). Check that disk space is available. In UNIX, your personal account does not have to have write access to the directory and table files; however, they must be writable to the group-id informix.

Informix Error Code -2021 An illegal color has been specified. Colors 0 through 7 are white, yellow, magenta, red, cyan, green, blue, and black.
Both in a COLOR attribute in a form specification and in a display attribute in a 4GL program, you must specify colors by name and spell them as this message shows. Check the spelling and punctuation of the statement.
Informix Error Code -2022 This identifier exceeds the maximum length for identifiers, which is length.
Names of fields and other identifiers cannot exceed the length that is shown. Revise the form specification, and recompile it.
Informix Error Code -2023 This quoted string exceeds the maximum length for quoted strings, which is length.
You cannot use longer quoted strings. In a form, you cannot join shorter strings to make longer ones, so this maximum is an absolute length limit. You must revise the form specification and recompile it.

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 *