Informix Error Messages and Error Codes From Error 4345 to 4349


Informix Error Code -4345 The variable variable-name has already had substrings applied to it.
The name that is shown is followed by one substring expression (two numbers in square brackets) and then by another. This is not valid. Perhaps some punctuation was deleted accidentally in editing the name of another variable. Or if you meant this to be a subscript of a two-dimensional array of character items followed by a substring of the chosen element, the problem is that variable-name has not been defined as an array.

Informix Error Code -4346 Subscripts can contain only INTEGER or SMALLINT expressions.
Array subscripts are integer values, and only integer variables can be used to form them. This statement contains a subscript in which a FLOAT, CHAR or some other type of variable is used. No automatic conversion of data types is performed in a subscript expression. Review the subscript expressions in the statement; perhaps you simply entered the wrong variable name. If not, you will have to revise the program to store array subscripts in integer variables only (you might expect that a DECIMAL value with a scale factor of zero would be permitted also, but this is not the case.)
Informix Error Code -4347 The variable variable-name is not a record. It cannot reference record elements.
In this statement variable-name appears followed by a dot, followed by another name. This is the way you would refer to a component of a record variable; however, variable-name is not defined as a record. Either you have written the name of the wrong variable, or else variable-name is not defined the way you intended.

Informix Error Code -4348 This type of aggregate must be applied to an expression, not ‘*’. Only PERCENT and COUNT aggregates use ‘*’.
An aggregate function in this statement is one of those, such as MIN and SUM, that must be applied to a specific column or to an expression involving specific columns. The asterisk notation in an SQL statement means “the whole row.” With an aggregate function, it is useful only when counting entire rows.
Informix Error Code -4349 The PERCENT and COUNT report aggregates cannot be used with an expression.
These aggregate functions simply count entire rows, without regard for the contents of the rows. COUNT returns a count of the rows, and PERCENT returns the count of rows as a percentage of the entire table. The only permitted parameters of these functions ‘*’ mean “the entire row.” They cannot be applied to specific columns or to expressions that involve specific columns.

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.

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 *