Informix Error Messages and Error Codes From Error 9803 to 9810


Informix Error Code -9803 Cannot create typed view view_name. Incompatible.
The column names and the column types of the view do not match the field names and the field types of the type. Change them to match.
Informix Error Code -9804 Cannot generate ROWIDS on typed table table_name.
Cannot have a ROWIDS column in a typed table. Either untype the table with ALTER TABLE or do not create a ROWID column.

Informix Error Code -9805 SERIAL/SERIAL8 data types allowed only as table column types.
You cannot have SERIAL/SERIAL8 data types in CREATE ROW statements. They are allowed only as table-column types.
Informix Error Code -9807 Temporary table temptable_name cannot be created with a type.
You cannot create temporary tables with types; typed tables are only for permanent tables. Instead, try using the following example to create a temporary table:
CREATE TEMP TABLE tablename OF TYPE subty;

Informix Error Code -9810 Smartblobs error.
You need to have an sbspace created and specified as the default value for the SBSPACENAME parameter in your onconfig file. If you do not have such an sbspace created and specified as the default in your onconfig file, the following example fails:
SBSPACENAME test_sbspace #default sbspace in onconfig file
onspaces -c -S test_sbspace -g 1 -p -o 0 -s 10000

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 *