Informix Error -6001: The database or table does not exist.

Reasons / Common Causes

-6001 fires when the database or table name given to an ALL-library function doesn't resolve — per the archived catalogue, this means the name is wrong, the wrong database is current, or the database/table has since been altered.

1. An incorrect database or table name, per the archived catalogue — the direct cause.
2. The wrong database currently selected, per the archived catalogue.
3. The database or table having been altered or dropped since the program was last run, per the archived catalogue.

Solutions / Resolution

1. Verify the database and table names passed to the function.
2. Confirm the intended database is actually the current one.
3. If the names are correct, check whether the schema has changed since the program was written or last tested.

Examples

N/A

No specific triggering statement is documented beyond the function-level condition described above.

Diagnostic Checks

1. Confirm the database/table name and current database selection are both as intended.

Related Errors / Related Topics

• -6000 — "Tried to perform an operation on an unopened table or database. Database not yet opened."
• -6002 — "Tried to open more than one database."
• -6004 — "No database open."
• -6005 — "A column cannot be found."

An unresolved database or table name — check for a typo, the wrong current database, or a schema change since the program was last run.