In this blog post, let’s learn about the error message “222 Cannot write to temporary file for new table table-name.” in Hydra and the description of the error.
Error Message
222 Cannot write to temporary file for new table table-name.
Error Details
Every SELECT statement must include a FROM clause to name the table or tables that it queries. Check that FROM was spelled and that no extra semicolon ends the statement prematurely. To select only a constant, or to select the only value of a function that is unrelated to any table (such as USER or TODAY), you nevertheless have to name a table. You can select a known row from a system catalog, as in this example.
SELECT today is, TODAY, and I am, USER FROM systables WHERE tabid = 100
The tabid value of the first user-defined table in a database is always 100, so this query always returns exactly one row if any tables are defined. (Version 4.1 and later produce syntax error -201 when the FROM clause is missing.)
Cannot begin savepoint.
Version 4.1 and later can detect this internal error. If the error recurs, please note all circumstances and contact Informix Technical Support.