Informix Error -839

-839 Table not found.

You specified the name of a table that does not exist in the current database. Review the spelling of the table name, and check that you are using the correct database. Refer to the discussion of error -310 for a way to display all table names.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-839 fires when a named table doesn't exist in the current database — per the official guidance, this is the interactive-tool-context counterpart to a general "table not found" condition, resolved the same way as reviewing -310's discussion for listing existing tables.

A misspelled table name, per the official guidance — the most common, direct cause.
Connected to the wrong database, per the official guidance — the table exists, just not in the database the current session is connected to.

Solutions / Resolution

Review the spelling of the table name, per the official guidance.
Check that the correct database is connected, per the official guidance.
Query systables to display all table names, per the official guidance's pointer to -310's discussion:
```
SELECT tabname, owner FROM systables WHERE tabtype = 'T';
```

Examples

Listing existing tables

SELECT tabname, owner FROM systables WHERE tabtype = 'T';

Diagnostic Checks

Check spelling and the currently connected database, then query systables to confirm what actually exists.

Related Errors / Related Topics

-310 — "Table table-name already exists in database." Referenced directly by this error's own official text for the systables listing technique.
-827 — "Database not found." A related error, about the database itself not being found rather than a table within an already-connected database.

Check spelling and the connected database first, then query systables to confirm what actually exists.