Informix Error Messages and Error Codes From Error 4401 to 4406


Informix Error Code -4401 A concatenation operation has created a string too long to fit in the destination string variable.
This statement concatenates two or more character strings and stores the result in another variable of type CHAR or VARCHAR. However, the result of concatenation was longer than the receiving variable. If the excess length is due to trailing spaces, you can use the CLIPPED function to prevent them from being included in the combined result. Otherwise you will have to define the length of the receiving variable as at least the sum of the lengths of the input variables.
Informix Error Code -4402 In this type of statement, subscripting may be applied only to array variables to select individual array elements.
The statement contains a name followed by square brackets, but the name is not that of an array variable. Check the punctuation of the statement and the spelling of all names. Names that are subscripted must be arrays. If you intended to use a character substring in this statement, you will have to revise the program.

Informix Error Code -4403 The number of dimensions for the variable variable-name does not match the number of subscripts.
In this statement, the array whose name is shown is subscripted by a different number of dimensions than it was defined to have. Check the punctuation of the subscript. If it is as you intended, then review the DEFINE statement where variable-name is defined.
Informix Error Code -4405 The function has exceeded the maximum number of allowed parameters.
This message is not returned by any current Informix product. If the error recurs, please note all circumstances and contact Informix Technical Support.

Informix Error Code -4406 There is an unmatched quote in the above line.
The source line contains an odd number of quote symbols. Inspect it from left to right and make sure that all literal character strings begin and end with a quote. All literal strings must begin and end on the same logical line. However, you can write long literal strings in two ways. First, you can escape the end of line by making the final character in the line a backslash (however, there is a fixed maximum of 80 characters on the total length of a single quoted string). Second, in the DISPLAY and LET statements, you can concatenate shorter literal strings using the comma. Here are two examples.
DISPLAY “abcdefghijkl\
DISPLAY “abcdefghijkl”,
Both display the alphabet with no embedded white space.

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 *