Informix Error -6005: A column cannot be found.
Cause and resolution
A column cannot be found.
At least one of the column names passed to this function does not exist in the table whose name was passed. Review the name of the table and the names of the columns. If they are correct, either the wrong database has been selected, or the database has been altered.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-6005 fires when at least one column name passed to the function doesn't exist in the opened table — per the archived catalogue, the name may be wrong, the wrong database may be current, or the table may have been altered.
- An incorrect column name, per the archived catalogue.
- The wrong database currently selected, per the archived catalogue.
- The table having been altered since the program was last run, per the archived catalogue.
Solutions / Resolution
- Verify the table and column names.
- Confirm the correct database is current.
- If names are correct, check whether the table's columns changed.
Examples
N/A
No specific triggering statement is documented beyond the function-level condition described above.
Diagnostic Checks
- Confirm each column name actually exists in the table, in the current database.
Related Errors / Related Topics
- -6001 — "The database or table does not exist."
- -6007 — "Column or index cannot be found in the current table."
A column name that doesn't resolve against the opened table — check spelling, the current database, and whether the table's columns have changed.