Informix Error Messages and Error Codes From Error 9046 to 9049


Informix Error Code -9046 The report output file filename could not be opened. This is probably due to permissions.
The report was directed to the destination shown, either with a REPORT TO statement or through the contents of the DBPRINT environment variable. Make sure that the destination was spelled correctly. Verify that your account has operating-system permissions to write the destination file and that the destination disk is writable and not full.
Informix Error Code -9047 The output file filename could not be created.
Probably your account does not have write permission in that directory, the disk is full, or you have exceeded a limit on open files.

Informix Error Code -9048 The pipe pipe-specification could not be opened.
The report was directed to the pipe that is shown in the REPORT TO statement. Make sure that all program names in it are spelled correctly, that the programs exist, and that they are on the current execution path. Look for other messages from the operating system that might indicate the source of trouble (for example, a message that indicates not enough system memory was available).

Informix Error Code -9049 A value entered as a command line parameter cannot be converted to the data type type.
A PARAMETER statement in the DEFINE section defines one of the values from the command line as having data type type. However, the value that is given on the command line cannot be converted to that type. Check the following points:

If type is numeric, check that the parameter can be read as a number.
If type is MONEY, the parameter should nevertheless not include a currency symbol.
If type is CHARACTER or VARCHAR, check that the parameter is not longer than the length that is defined for the variable.
If type is DATETIME, check that the parameter is correctly punctuated (refer to the appendix on DATETIME and INTERVAL data in the user guide).
If type is DATE, check that the parameter is correctly punctuated as a date.
Correctly punctuated DATE, DATETIME and INTERVAL values contain characters that might have special meaning to the operating system. The problem might be that the parameter was correct but needed quotes around it to protect it.

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 *