Informix Error -6007: Column or index cannot be found in the current table.
Cause and resolution
Column or index cannot be found in the current table.
The column name passed to this function does not exist in the table. Review the spelling of the name. If it is correct, either the wrong database is selected or the table has been altered.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-6007 fires when the column name passed doesn't exist in the table — per the archived catalogue, check spelling first, then the current database, then whether the table has been altered.
- An incorrect or misspelled column name, per the archived catalogue.
- The wrong database currently selected, per the archived catalogue.
- The table having been altered, per the archived catalogue.
Solutions / Resolution
- Check the spelling of the column name.
- Confirm the correct database is selected.
- If the name is correct, check whether the table was altered.
Examples
N/A
No specific triggering statement is documented beyond the function-level condition described above.
Diagnostic Checks
- Confirm the column genuinely exists in the current table, in the current database.
Related Errors / Related Topics
- -6005 — "A column cannot be found."
A column/index name that doesn't resolve — check spelling, the current database, and whether the table has changed.