Informix Error Messages and Error Codes From Error 1374 to 1379

SQLServerF1

Informix Error Code -1374 SQL character truncation or transaction warning.
The program set WHENEVER WARNING STOP, and a warning condition arose. If the statement involved is a DATABASE statement, the condition is that the database that was just opened uses a transaction log. On any other statement, the condition is that a character value from the database had to be truncated to fit in its destination.
Informix Error Code -1375 SQL NULL value in aggregate or mode ANSI database warning.
The program set WHENEVER WARNING STOP, and a warning condition arose. If the statement that is involved is a DATABASE statement, the condition is that the database that was just opened is ANSI compliant. On any other statement, the condition is that a null value has been used in the computation of an aggregate value.

Informix Error Code -1376 SQL, database server, or program variable mismatch warning.
The program set WHENEVER WARNING STOP, and a warning condition arose. If the statement that is involved is a DATABASE or CREATE DATABASE statement, the condition is that the database server opened the database. On any other statement, the condition is that a SELECT statement returned more values than there were program variables to contain them.

Informix Error Code -1377 SQL float-to-decimal conversion warning.
The program set WHENEVER WARNING STOP, and a warning condition arose. The condition is that in the database that was just opened, the database server will use the DECIMAL data type for FLOAT values.
Informix Error Code -1378 SQL non-ANSI extension warning.
A database operation was performed that is not part of ANSI SQL, although the current database is ANSI compliant. This message is informational only.
Informix Error Code -1379 Report functions may not be called directly. Please use the OUTPUT TO REPORT statement.
A report function has been entered as a result of a CALL statement. Report functions can only be executed using the START REPORT, FINISH REPORT, and OUTPUT TO REPORT statements. Review the program. Look for places where the report function name is called like a normal function, and change them. If you want to use some of the code in the report function as a subroutine, place it in a separate subroutine, and call it from the report function and other places.

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 *