Informix Error Messages and Error Codes From Error 1329 to 1333

SQLServerF1

Informix Error Code -1329 A database index could not be created for a temporary database table needed for a report.
Within the report definition, 4GL generated SQL statements to save rows into a temporary table. However, an index could not be created on the temporary table. Probably an index with the same name already exists in the database. (The sorting index is named “i_reportname”; for example, “i_order_rpt”.) Possibly no disk space is available in the file system or dbspace. Another possibility with some database servers is that you have exceeded an operating-system limit on open files. Look for other error messages that might give more details.

Informix Error Code -1330 A row could not be inserted into a temporary report table.
Within the report definition, 4GL generated SQL statements that would save rows into a temporary table. However, an error occurred while rows were being inserted. Probably no disk space is left in the database. Look for other error messages that might give more details.
Informix Error Code -1331 A row could not be fetched from a temporary report table.
Within the report definition, 4GL generated SQL statements to select rows from a temporary table. The table was built successfully but now an error occurred while rows were being retrieved from it. Almost the only possible cause is a hardware failure or an error in the database server. Check for operating-system messages that might give more details.

Informix Error Code -1332 A character variable has referenced subscripts that are out of range.
In the current statement, a variable that is used in taking a substring of a character value contains a number less than one or a number greater than the size of the variable, or the first substring expression is larger than the second. Review the program logic that leads up to this statement to find the cause of the error.
Informix Error Code -1333 Strings of length > 512 cannot be returned from function calls.
The current RETURN statement contains an expression that evaluates to a character string longer than 512 characters. This situation is not supported. Review the logic of the function, and modify it so that it does not return such a long character value. You can assign a longer string to a global 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 *