Informix Error Messages and Error Codes From Error 33037 to 33042


Informix Error Code -33037 Name is not a component of record record-name.
Name is used as if it were a member of the record record-name, but no member of that name exists. Check the spelling of the two names, and review the declaration of record-name.
Informix Error Code -33038 This statement does not conform to the X/Open standard.
This message is a warning only. You used the -xopen option, asking that the source file be checked for compliance with the XPG4 X/Open standard.

Informix Error Code -33039 Updates are not allowed in singleton select.
You have an UPDATE statement in combination with a SELECT statement that returns only one row. The UPDATE statement requires a cursor that has been declared FOR UPDATE. See the DECLARE, SELECT, and UPDATE statements in the Informix Guide to SQL: Syntax for more information about cursors.

Informix Error Code -33040 Object hostvar was not declared.
The host variable hostvar is either not declared, or it is misspelled. If hostvar is not declared as a host variable, declare it. Otherwise, correct the misspelling.
Informix Error Code -33041 Cannot open output file outfile.
The preprocessor cannot open outfile because not enough disk space is available, or you do not have file-system permission to open the file. If insufficient disk space is available, delete files or select another disk to make space available in the file system. If you do not have file-system permission to open outfile, specify another directory or login with the required permission.
Informix Error Code -33042 Cannot open input file inputfile.
The embedded-language preprocessor cannot locate the file that you are trying to include in your program with the -I option. Check that the file is in the location that you have specified and that you have specified the location correctly. Also check that you have permission to open inputfile; if you do not, specify another directory or login with the required permission.

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 *