Informix Error Messages and Error Codes From Error 4475 to 4486

SQLServerF1

Informix Error Code -4475 “name” may not be used as both a function (or report) name and an identifier.
The name shown has been defined at least two ways. Names at the global or module level must be unique. Locate all the definitions and declarations of this name and change all but one of them. Error -4475 is issued with this meaning from 4GL at versions after 4.1.
Informix Error Code -4476 Record members may not be used with database column substring. Possible misspelling or usage of undefined host variables.
This statement has a reference of the form name1.name2[…]. This is the form in which you would refer to a substring of a column: table.column[…]. However, the names are not a table and column in the database, so 4GL presumes they refer to a field of a record. Inspect the statement and determine what was intended: a reference to a column or to a record. If it is a column reference, verify the names of the table and column in the database. If it is a record reference, verify that the record and component are properly defined. If the record has the same name as a table, prefix the name of the table with @ to make it clear you mean the table, not the record.

Informix Error Code -4479 Warning: non-ANSI comment indicator. Use “–” for ANSI compatibility.
If you want your SQL statements to comply with ANSI standards, you must use the two-dash comment delimiter (- -). The comment delimiters of the number sign (#) and the braces ({ }) are not portable to ANSI-compliant systems. This message is seen because you specified that you wanted warnings issued for constructs that are not ANSI compliant, by means of the -ansi command-line parameter, the DBANSIWARN environment variable, or the DBANSIWARN setting in the informix.ini file. Only NewEra returns this error.

Informix Error Code -4479 Warning: non-ANSI comment indicator. Use “–” for ANSI compatibility.
If you want your SQL statements to comply with ANSI standards, you must use the two-dash comment delimiter (- -). The comment delimiters of the number sign (#) and the braces ({ }) are not portable to ANSI-compliant systems. This message is seen because you specified that you wanted warnings issued for constructs that are not ANSI compliant, by means of the -ansi command-line parameter, or the DBANSIWARN environment variable. Only 4GL returns this error.
Informix Error Code -4486 TEXT or BYTE variables and wordwrap fields cannot be printed in report headers or trailers.
4GL has to be able to predict how many lines will be used in a report header or trailer. Because the size of a TEXT variable is unpredictable, you cannot display one in these contexts.

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 *