Informix Error Messages and Error Codes From Error 4438 to 4451

SQLServerF1

Informix Error Code -4438 You cannot SELECT into a substring of a character variable.
Substring notation is not allowed in the INTO clause. You can specify a substring of a column in the list of columns to select and in the WHERE clause. But you have to select into an entire variable. Define a variable to select into, and move the data into the destination substring using a LET statement.
Informix Error Code -4439 You cannot SELECT into record record because element name is a record or an array.
The INTO clause can name only simple variables. The use of asterisk or THRU notation is a shorthand for listing all the component fields of a record. The resulting list of fields must consist of simple variables. In this case, the field name is not simple. Perhaps you have referred to the wrong record. If not, you will have to list the name component separately, specifying one or more of its component parts.

Informix Error Code -4440 name1 precedes name2 in the record/object and must also precede it when used with the THROUGH shorthand.
The THROUGH or THRU shorthand requires you to give the starting and ending fields as they appear in physical sequence in the record. Check the spelling of the names; if they are as you intended, then refer to the VARIABLE statement where the record was defined to see why they are not in the sequence you expected. Only NewEra returns this error.
Informix Error Code -4440 The field name1 precedes name2 in the record record-name and must also precede it when used with the THROUGH shorthand.
The THROUGH or THRU shorthand requires you to give the starting and ending fields as they appear in physical sequence in the record. Check the spelling of the names; if they are as you intended, then refer to the DEFINE statement where the record was defined to see why they are not in the sequence you expected. Only 4GL returns this error.

Informix Error Code -4448 Cannot open the file filename for reading or writing.
Verify that the filename is correctly spelled and that your account has permission to read or write to it.
Informix Error Code -4451 The size of the pcode generated from this function/report has exceeded the 32K per function limit.
The function or report will have to be simplified. Extract some portion of its code to a separate function or report, and call that one. Only NewEra returns this error.

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 *