Informix Error Messages and Error Codes From Error 1268 to 1273

SQLServerF1

Informix Error Code -1268 Invalid datetime or interval qualifier.
This statement contains a DATETIME or INTERVAL qualifier that is not acceptable. These qualifiers can contain only the words YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, FRACTION, and TO. A number from 1 to 5 in parentheses can follow FRACTION. Inspect the statement for missing punctuation and misspelled words. A common error is adding an s, as in MINUTES.
Informix Error Code -1269 Locator conversion error.
This message was issued because a function that requires an argument that is a locator (a reference to a BYTE or TEXT value) received something other than a valid locator (such as a NULL parameter). Review the program logic to make sure the arguments are correct. If the error recurs, please note all circumstances and contact Informix Technical Support.

Informix Error Code -1270 Interval literal may not have embedded minus sign.
You can use a minus sign as an arithmetic operator between an INTERVAL literal and other values, and you can use a minus sign as a prefix to an INTERVAL literal to indicate it is a negative quantity. However, you cannot embed a minus sign among the fields of the literal. If you did not intend to do this, inspect the statement for missing or misplaced punctuation.
Informix Error Code -1271 Missing decimal point in datetime or interval fraction.
A decimal point is expected to appear in a DATETIME or INTERVAL literal when the qualifier of the literal contains the word FRACTION. This statement has such a literal, but no decimal point was found. Inspect the literal qualifiers for missing or misplaced punctuation.

Informix Error Code -1272 No input buffer has been specified.
You have not specified an input string for this function, so the conversion cannot proceed. Set the input-string argument, and call the function again. (This function might require that you define formatting directives with the DBTIME environment variable.)
Informix Error Code -1273 Output buffer is NULL or too small to hold the result.
This error is returned when the function is called and the address space for the output buffer is null or smaller than the format-string length. Redefine the size of the address, and execute the function again. (This function might require that you define formatting directives with the DBTIME environment variable.)

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 *