Informix Error Messages and Error Codes From Error 19813 to 21002

SQLServerF1

Informix Error Code -19813 Cannot add CRCOLS when table already has replication shadow columns.
The specified table was created with the WITH CRCOLS syntax and therefore already has the replication shadow columns defined. You cannot alter this table to add CRCOLS to it.
Informix Error Code -19814 Cannot drop CRCOLS when table does not have replication shadow columns.
The specified table was not created with the WITH CRCOLS syntax, or it has not been altered to include the CRCOLS. You cannot alter this table and drop the CRCOLS because these columns do not exist on this table.

Informix Error Code -19815 Cannot create a temp table with CRCOLS.
You cannot create a temporary table to include the replication shadow columns.
Informix Error Code -19816 Cannot perform this operation on a table defined for replication.
The specified operation cannot be perform on a table if replication is defined on the table. If you want to perform the specified operation, you must delete all replicates defined on this table.

Informix Error Code -21000 Invalid byte in codeset conversion input.
Code-set conversion cannot recognize data that is being passed between the server and the client. Check DB_LOCALE and CLIENT_LOCALE settings in your initialization file or your environment.
Informix Error Code -21001 Incomplete character at end of codeset conversion input.
Code-set conversion cannot recognize data that is being passed between the server and the client. Check DB_LOCALE and CLIENT_LOCALE settings in your initialization file or your environment.
Informix Error Code -21002 Codeset conversion output buffer too small.
An internal error occurred during code-set conversion. Note all observed behavior and any other error message. Check with the system administrator to ensure that the system is functioning properly.

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 *