Informix Error Messages and Error Codes From Error 8107 to 8112

SQLServerF1

Informix Error Code -8107 A user variable or parameter has been defined by the user more than once.
You can define a name only once in a DEFINE section. You used a name more than once in the ASCII, PARAM, or VARIABLE statements.
Informix Error Code -8108 A user variable or parameter must have a length which is greater than zero.
Make sure that every CHAR and VARCHAR field in the DEFINE section has a nonzero length specification.

Informix Error Code -8109 Wordwrap may not be used within PAGE HEADERS or TRAILERS.
ACEPREP needs to know how many lines will be filled in header and trailer sections (otherwise, it does not know how many detail rows to put on the page). However, printing with the WORDWRAP function can fill a variable number of lines, depending on the words. Therefore, it is not allowed in page header or trailer sections.
Informix Error Code -8110 The user variable called name has not yet been defined.
The variable, parameter, or field name was not defined in the DEFINE section. If name is spelled correctly, it must be defined.

Informix Error Code -8111 User variables and run-time parameters may not be used in an ORDER BY statement.
Only names of columns can be used in an ORDER BY clause. Check the spelling of the column names or display labels in the clause. You cannot request ordering by the contents of defined variables, parameters, or ASCII fields.
Informix Error Code -8112 Within an IF-THEN-ELSE statement of a header or trailer clause, the number of lines printed in the IF part must equal the number of lines printed in the ELSE part.
ACEPREP needs to know how many lines will be filled in header and trailer sections (otherwise, it does not know how many detail rows to put on the page). Because it cannot tell which part of an IF statement will be executed, it requires that both produce the same number of lines of output.

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 *