Informix Error Messages and Error Codes From Error 32400 to 32404


Informix Error Code -32400 A Table_option has already been altered.
You can change only one table option (locking mode, extent size) for each ALTER TABLE session. If you have changed one table option and want to change another, you must first exit the ALTER TABLE Menu and build the modified table. Select the Exit option, then the Build-new-table option. Then select the Table_options option on the ALTER TABLE Menu, and make your next modification to the table.
Informix Error Code -32401 The initial extent size cannot be changed when altering a table.
The initial-extent size is set when the table is first created. The next-extent size can be altered, but the initial-extent size cannot. To change the size of the initial extent, you must unload the data from the table, drop the table, re-create the table with the CREATE TABLE statement, and reload the data into the table.

Informix Error Code -32402 The user cannot change the dbspace name when altering an existing table.
You have specified the location in which to table is to be stored. You have explicitly specified a dbspace or the dbspace of the database has already been used. When you attempted to alter a table, you tried to change the dbspace in which the table is stored. This action is illegal. You can specify the dbspace only when you create the table.
Download any data in the existing table. Drop that table. Create a new table. Specify the dbspace that you want to use and upload the data into the new table.

Informix Error Code -32403 Illegal serial length has been used.
This error occurs when the user creates or alters a table and creates or alters a column of type serial but has specified that the starting number is less than or equal to zero (illegal) or has entered in a nonnumeric value. Enter a number equal to or greater than 1 for the starting number.
Informix Error Code -32404 Invalid delimiter. Do not use ‘\\’, hex digits, tab or space.
The delimiter that is specified for the LOAD or UNLOAD statement is illegal. You cannot use the new-line character, hexadecimal digits (0 to 9, A to F, a to f), the tab character, or a space as a delimiter. Check the statement and change the delimiter symbol.

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 *