Informix Error Messages and Error Codes From Error 1207 to 1212


Informix Error Code -1207 Converted value does not fit into the allotted space.
A noncharacter value, after conversion to a character string, is too long to fit in the buffer that was provided. If the conversion was automatic, change the program to provide a larger host variable to receive the string. If this action was an explicit call to conversion function, pass a larger buffer.
Informix Error Code -1208 There is no conversion from non-character values to character values.
If you are using a database server prior to Version 4.0, no automatic conversion from numeric values to character values occurs in SQL statements such as INSERT and UPDATE. Check that the specified value for each column agrees with the data type of that column. If you use a Version 4.0 or later database server, this message should not appear.

Informix Error Code -1209 Without any delimiters, this date must contain exactly 6 or 8 digits.
When a literal date value is entered in numeric form, not enclosed in quotes to make it a character string, it must be entered as a number of precisely 6 digits (representing mmddyy) or 8 digits (representing mmddyyyy). Because no punctuation is present, a date with any other number of digits is ambiguous; it cannot be divided into month, day, and year with certainty.

Informix Error Code -1210 Date could not be converted to month/day/year format.
The DATE type is compatible with the INTEGER type, but not all integer values are valid dates. This error arises in attempts to convert to character from a date whose numeric value is less than -693,594 or greater than 2,958,464. Numbers that are outside this range have no representation as dates.
Informix Error Code -1211 Out of memory.
4GL cannot allocate memory for a small, temporary work area that is used for processing an expression. To avoid this error, simplify the program in almost any way to release enough space
Informix Error Code -1212 Date conversion format must contain a month, day, and year component.
When a date value is converted between internal binary format and display or entry format, a pattern directs the conversion. When conversion is done automatically, the pattern comes from the environment variable DBDATE. When it is done with an explicit call to the rfmtdate(), rdefmtdate(), or USING functions, a pattern string is passed as a parameter. In any case, the pattern string (the format of the message) must include letters that show the location of the three parts of the date: 2 or 3 letters d; 2 or 3 letters m; and either 2 or 4 letters y.

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 *