Informix Error Messages and Error Codes From Error 29037 to 29042


Informix Error Code -29037 There is no CCSID or GLS locale set for the FE OS locale localename.
The locale in question is returned as a token in SQLERRM.
Notify the Gateway administrator. The administrator can add an entry for the locale using the gwdba utility.

Informix Error Code -29039 Cannot have more than one SQL statement in PREPARE/EXECUTE IMMEDIATE.
Modify the application so that it does not include more than one SQL statement in a PREPARE or EXECUTE IMMEDIATE statement.
Informix Error Code -29040 Cannot translate MATCHES pattern to LIKE pattern.
The Gateway does not support and cannot translate one or more characters in the MATCHES condition of your SQL statement. Try to rewrite the statement to use LIKE instead of MATCHES condition syntax or to not include MATCHES wildcard characters such as [ ] and ? or *. Check also that you did not try to include a non-CHAR or VARCHAR column with MATCHES in the WHERE clause.

Informix Error Code -29042 Package info for RDB rdbname not found. Use gwdba to bind.
The Gateway package information for the target RDB is not found. It appears that the necessary Gateway packages on the RDB have not been bound yet. The real_RDB_name of the target RDB is returned as a token in SQLERRM.
The end user should contact the DBA. If desirable, the DBA can use the gwdba utility to bind the needed Gateway packages on the target RDB.

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 *