Informix Error Messages and Error Codes From Error 9061 to 9064


Informix Error Code -9061 A ‘SELECT INTO’ statement cannot be executed as the last select statement in an ACE report.
The SELECT section of the report can contain more than one SELECT statement. The last (or only) one of these statements must produce the rows that are the contents of the report. Any preceding SELECT statements are used to prepare data in temporary tables that the final statement delivers to the report. Change the report specification so that all but the last SELECT statement contain INTO TEMP clauses.
Informix Error Code -9062 An error has occurred during the conversion of a numeric value to a CHARACTER type user variable. The CHARACTER type variable is not long enough to hold the result.
The conversion of a numeric value to character produced more numeric characters than the destination could hold. Rather than truncate the result, ACEGO stops with an error. You can either redefine the destination variable, or you can limit the size of the converted value (for example, with a USING format string).

Informix Error Code -9063 The user function name, defined by the user in the DEFINE statement of ACE, could not be found in the C function definition table userfuncs in the user’s C static data area.
The DEFINE section of the report contains a FUNCTION statement indicating that an external function name would be linked with the report. (The ESQL/C manual covers the use of external C functions with ACE reports and PERFORM screens.) However, the name and address of each such function must appear in a static array that is named userfuncs. That array, along with the computer code of the external functions, is linked with a custom version of ACEGO. Because name did not appear in the array, ACEGO cannot call it.
Check that you are executing the correct, customized version of ACEGO (the original version of the program has no external functions linked to it). Check to see if name is correctly spelled. Then examine the source of the C functions to make sure that the userfuncs array is defined correctly and that it contains an entry for name.

Informix Error Code -9064 The run-time string table is full. No more memory can be allocated.
The data space available for temporary character strings is full. Temporary strings are built when calling external C functions and when processing the USING, SPACE, and ASCII built-in functions. Reduce the use of these items.

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 *