Informix Error -6043: Column is not a composite key.
Cause and resolution
Column is not a composite key.
The columname parameter that was passed to dbselfield() is not the name of a column in the specified table, nor is it the name of a composite index on that table. Review the tablename and columname parameters. If they are as you intended, check that the correct database has been selected. If so, the desired index might have been dropped or created under a different name.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-6043 fires when dbselfield()'s columname parameter names neither a column nor a composite-index name on the table — per the archived catalogue, the index may have been dropped or re-created under a different name.
- An incorrect columname value, per the archived catalogue.
- The correct database not being selected, per the archived catalogue.
- The intended index having been dropped or renamed, per the archived catalogue.
Solutions / Resolution
- Review the tablename and columname parameters.
- Confirm the correct database is selected.
- If parameters look correct, check whether the index was dropped or renamed.
Examples
N/A
No specific triggering statement is documented beyond the function-level condition described above.
Diagnostic Checks
- Confirm columname actually names a column or composite index on the table in the current database.
Related Errors / Related Topics
- -6026 — "The named column must be indexed or sequential search must be selected."
- -6052 — "Not all of the composite index is contained in the current view of this table."
columname doesn't resolve to a column or composite index — check spelling, the current database, and whether the index was dropped or renamed.