Informix Error Messages and Error Codes From Error 23936 to 23950

SQLServerF1

Informix Error Code -23936 There are GK-indexes depending on a table in the statement.
This statement cannot be executed because general-key indexes exist that depend on a table or tables involved in the statement. Drop the general-key index that depends on the table.
To determine which GK indexes need to be dropped to correct this error, run the following query on the system catalog table:

SELECT sysindexes.idxname, sysindexes.owner
FROM systables, sysindexes, sysnewdepend WHERE systables.tabname = “” AND systables.tabid = sysnewdepend.destid1 AND sysnewdepend.srcid2 = sysindexes.tabid AND sysnewdepend.srcid1 = sysindexes.idxname
When a particular column of the GK index is involved (for example, in the case of a RENAME COLUMN statement), run the following query to determine which GK indexes need to be dropped:

SELECT sysindexes.idxname, sysindexes.owner
FROM sysindexes, systables, syscolumns, sysnewdepend WHERE systables.tabname = “” AND syscolumns.colname = “” AND systables.tabid = sysnewdepend.destid1 AND syscolumns.colno = sysnewdepend.destid2 AND sysnewdepend.srcid2 = sysindexes.tabid AND sysnewdepend.srcid1 = sysindexes.idxname
Informix Error Code -23937 GK-index creation: table (table_name) isn’t join-on-key to the indexed table. The error message shows the name (table_name) of the table that is not correctly joined in the WHERE clause of the statement. Change the WHERE clause to include an equality test.
Informix Error Code -23950 XBAR error: Error during dbspace backup.
Refer to the ONBar activity log and server message log for more information.

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 *