Informix Error Messages and Error Codes From Error 22277 to 22283

SQLServerF1

Informix Error Code -22277 Invalid storage mode. Assuming byte-storage mode.
Micro-Focus COBOL/2 has either byte or word storage mode for USAGE COMP/BINARY variables. Check the current storage mode. To specify byte or word storage, set the INFORMIXCOBSTORE environment variable, as Chapter 4 of the Informix Guide to SQL: Reference discusses.
Informix Error Code -22278 Cannot open COBOL ‘whenever’ file file-name.
The directory in which the COBOL temporary files are being created (usually /tmp or whatever is specified when the DBTEMP environment variable is set) is full. No room is available to open new files. Check this directory and free some space. Since Version 5.01, the INFORMIX-SE database server uses the DBTEMP environment variable, but Informix Dynamic Server and INFORMIX-OnLine Dynamic Server do not.

Informix Error Code -22279 Cannot open COBOL temp file file-name.
The directory in which the COBOL temporary files are being created (usually /tmp or whatever is specified when the DBTEMP environment variable is set) is full. No room is available to open new files. Check this directory and free some space. Since Version 5.01, the INFORMIX-SE database server uses the DBTEMP environment variable, but Informix Dynamic Server and INFORMIX-OnLine Dynamic Server do not.

Informix Error Code -22280 Line is too long.
The SQL string in the EXEC SQL statement is too long to fit in the internal buffer. The maximum SQL string length should be less than 32,767.
Informix Error Code -22281 FILLER variables can only be used as fields in a record.
In INFORMIX-ESQL/COBOL, the FILLER keyword must identify all filler items. Filler variables can only be used as fields in a record and must also have a PIC clause associated with them. Check the declaration of the variable and change its name.
Informix Error Code -22282 Invalid numeric data length.
The length and precision of the data is too large or otherwise incorrect. The length cannot be greater than 18, and the precision cannot be greater than the length.
Informix Error Code -22283 Numeric value from database cannot be stored in COBOL data item.
In INFORMIX-ESQL/COBOL, a number of conditions can cause this error message to appear. The value is too large, data cannot contain a negative value, a signed value cannot be stored in an unsigned data item, or a float overflow has occurred.

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 *