Informix Error Messages and Error Codes From Error 346 to 350

SQLServerF1

Informix Error Code -346 Could not update a row in the table.
While the database server was processing an UPDATE, it received an unexpected error. Check the accompanying ISAM error code for more detailed information on the cause. Possible causes include hardware errors and locking conflicts.
Informix Error Code -347 Could not open table for exclusive access.
The database server cannot complete a LOCK TABLE statement or the implicit LOCK TABLE that must be performed as part of other statements that change the definition of a table (for example ALTER TABLE, RENAME, or CREATE INDEX). Check the accompanying ISAM error code for more detailed information on the cause. Possible causes include lock conflicts, a full lock table, or low-level problems with the host operating-system lock mechanism.

Informix Error Code -348 Could not read a row from the table.
While the database server was trying to fetch a row from a table, it received an unexpected error. Check the accompanying ISAM error code for more detailed information on the cause. Possible causes include hardware errors and lock conflicts.
Informix Error Code -349 Database not selected yet.
This statement cannot be executed because no current database exists. Either no current database has been established yet, or the current database was closed with a CLOSE DATABASE statement. You execute the DATABASE or CREATE DATABASE statement to establish a current database.

Informix Error Code -350 Index already exists on column.
This CREATE INDEX statement cannot be executed because an index on the same column or combination of columns already exists.At most two indexes can exist on any combination of columns, one ascending and one descending. To display the indexes on a particular table, join sysindexes and systables. Supply table-name in the following statement:
SELECT * FROM sysindexes, systables
WHERE sysindexes.tabid = systables.tabid AND systables.tabname = ‘table-name’
The sysindexes table is not normalized (the part columns are a repeating group), so no simple SELECT statement will return all the column names in an index.

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 *