Informix Error Messages and Error Codes From Error 645 to 652

SQLServerF1

Informix Error Code -645 Cannot reserve volume.
An attempt to reserve an optical volume with the RESERVE statement has failed. See the error from the optical subsystem (an error in the -7000 to -7199 range) for more information.
Informix Error Code -646 Cannot release volume.
An attempt to release a requested optical volume with the RELEASE statement has failed. See the error from the optical subsystem (an error in the -7000 to -7199 range) for more information.
Informix Error Code -647 Error evaluating math library function function-name.
The data type of the argument is correct, but the value passed to the function is not appropriate for the math function. Check that you are passing a legitimate value to the function.
Informix Error Code -648 Cannot open DEBUG file for stored procedure trace.
An error occurred trying to open DEBUG trace file. This error can occur when one of the directories in the specified debug file name does not exist, or the directory is write protected. Check that the directory path is valid and that group informix can write to the directory.

Informix Error Code -649 The debug file name must be a NON-NULL CHAR or VARCHAR.
The argument that is specified for the debug file in the SET DEBUG statement must be a character data type.
Informix Error Code -650 Maximum varchar size has been exceeded.
This statement specifies a VARCHAR(m, r) column with a maximum width m greater than allowed (255). Check the punctuation of the column definition. If it is as you intended, redesign the table to use a VARCHAR width that ranges from 1 character to 255 characters.
Informix Error Code -651 Reserved column size > maximum column size (varchar).
This statement specifies a VARCHAR(m, r) column with a reserved width r that is greater than the maximum width m. Check the punctuation of the column definition. If it is as you intended, revise the statement so that m is greater than or equal to r.

Informix Error Code -652 Local variables do not allow default values.
An attempt was made to define a local variable with a default value. Only global variables and parameters can have default values.
An example of the error follows:
DEFINE var INT DEFAULT 10; — error
The correction is as follows:
DEFINE var INT; LET var = 10;

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 *