Informix Error -220

-220 There is no FROM clause in the query.

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.)

-220 Cannot begin savepoint.

Version 4.1 and later can detect this internal error. If the error recurs, note all circumstances and contact IBM Informix Technical Support.