Informix Error Messages and Error Codes From Error 9965 to 9975


Informix Error Code -9965 The maximum number of allowable sbspaces maximum_number has been exceeded.
The maximum number of 64 sbspaces per table has been exceeded, so your operation failed. For more information on the number of sbspaces associated with the table, run the following queries:
SELECT tabid FROM informix.systables
WHERE tabname = `’;
SELECT count(*) FROM informix.syscolattribs
WHERE tabid = ;

Informix Error Code -9967 Cannot find data type data_type_name.
The specified data type does not exist in the database. Check sysxtdtypes to make sure that the data type exists before you use it.
Informix Error Code -9970 Cannot determine host variable type during bind.
An ambiguous bind message was received. The database server could not infer the variable type from the context of the query. The host variable type must be explicitly defined.

Informix Error Code -9974 Cannot delete element from a ROW type.
You have attempted to delete a row from a host variable of type ROW. Because a ROW host variable has only the single row as its contents, deletion is not allowed. If you want to construct a row with NULL values, use an UPDATE statement and set each field to a NULL value. Otherwise, remove the request to execute the SQL DELETE for the row host variable in your embedded language program.
Informix Error Code -9975 Type of a table must be unique within a table hierarchy.
You cannot have siblings of the same type under the same parent. For example, assume that you create the following row types:
create row type r1 (a int);
create row type r2 under r1;
Now you attempt to create a supertable and two subtables. The third statement in the following set generates an error:
create table supertab of type r1;
create table subtab1 of type r2 under r1;
create table subtab2 of type r2 under r1;
The third CREATE TABLE statement generates an error because subtab1 and subtab2 would be siblings under supertab. Informix does not support this table hierarchy in this release. The current version of the database server restricts the table hierarchy to match the type hierarchy, and no type can appear more than once within a single hierarchy of tables.

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 *