Informix Error Messages and Error Codes From Error 6025 to 6030

SQLServerF1

Informix Error Code -6025 The table is already open.
This call to dbselect() passed the name of a table that is already open. The table continues to be open. Review the program logic to see if it is making redundant calls to dbselect().
Informix Error Code -6026 The named column must be indexed or sequential search must be selected.
This call to dbselfield() names a column that does not have an index in the database, but the flag passed was ACCKEYED. Check that the correct column was named and that the correct database and table have been opened. If that is the case, then the index has been dropped and should be re-created before you run the program again.

Informix Error Code -6027 Cannot insert a NULL value into a NOT NULL column.
This call to dbadd() or dbupdate() has attempted to insert a row that contains a null value for a column that is constrained to be not null. Possibly the program placed a null in the record buffer using dbsetnull(), or the current view omits a column that is constrained to be not null. The row is not inserted. Review the definition of the table and the program logic, and change it so that it to define values for all not null columns before an add or update.

Informix Error Code -6028 Tablename has not been opened.
A call to dbselect must first open the table that dbupdate() is to use. Review the program logic to make sure that this action is performed.
Informix Error Code -6029 No view has been set.
Before the program calls dbupdate(), it must call dbsetview() to establish a view (that is, a specification of the columns to be returned and the buffer to receive them). Review the program logic to see that this action is performed.
Informix Error Code -6030 Cannot add a duplicate value; the index has been defined as UNIQUE.
At least one of the column values that was presented to dbupdate() is a duplicate of a value that exists in its column. However, that column is constrained to contain unique values. The row cannot be inserted.

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 *