Informix Error -4320: The symbol table-name is not the name of a table in the specified database.
Cause and resolution
The symbol table-name is not the name of a table in the specified database.
The named table does not appear in the database that is named in the latest DATABASE statement. It may be spelled wrong in the program, or the table might have been dropped or renamed since the last time the program was compiled.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-4320 fires when a named table doesn't appear in the database named by the most recent
DATABASE statement — per the official guidance, this may be a spelling error, or the table
was dropped or renamed since the program was last compiled.
- A misspelled table name, per the official guidance — the first named cause.
- The table was dropped or renamed since the program was last compiled, per the official guidance — the second named cause.
Solutions / Resolution
- Check the table name's spelling, per the official guidance.
- Check whether the table still exists (or has been renamed) in the current database.
Examples
Checking the actual table names
SELECT tabname FROM systables WHERE tabtype = 'T';
Diagnostic Checks
- Check the table name's spelling against the actual database schema, and update the program if the table was renamed.
Related Errors / Related Topics
- -4322 — "The symbol column-name is not the name of a column in the specified database." A related schema-mismatch error, about a missing column rather than a missing table.
A named table doesn't exist in the current database — check its spelling and whether it was dropped or renamed.