Informix Error Messages and Error Codes From Error 23850 to 23854

SQLServerF1

Informix Error Code -23850 Table type specified twice.
The CREATE TABLE statement contains more than one table type.
Check the statement to make sure that only one table type is defined.

Informix Error Code -23851 This operation is not allowed on a table where the type is raw or scratch.
An illegal operation (for example, trying to create an index) has been attempted on a RAW or SCRATCH table.
You might want to alter the table type to a type that supports the operation.
Informix Error Code -23852 This operation is not allowed on a table where the type is static.
The statement issued tries to modify data in the table with an UPDATE, INSERT, or DELETE statement. Data modification is not allowed on tables of type STATIC. You might want to alter the type to one of the other types that support data modification.

Informix Error Code -23853 Unable to change the type of table tablename.
An error occurred when the database server tried to alter the type of the table. Possibly you tried to alter the table type to RAW when indexes are defined on the table, or you tried to change a table to STANDARD when an archive has not been made.
Informix Error Code -23854 Indexes and constraints are not allowed on tables of type is raw or scratch.
The CREATE TABLE statement contains indexes or constraints that are not allowed for RAW or SCRATCH tables. Check your statement to make sure you do not define these kinds of constraints or indexes on RAW or SCRATCH 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.

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 *