SELECT statements without a FROM clause [CR 462007]

When constant values are in SELECT statements that include UNION ALL views but omit a FROM clause, use iq_dummy to avoid errors.

If you omit the FROM clause, or if all tables in the query are in the SYSTEM dbspace, Adaptive Server Anywhere processes the query, instead of Sybase IQ, and might behave differently, especially with regard to syntactic and semantic restrictions and the effects of option settings.

If you have a query that does not require a FROM clause, you can force Sybase IQ to process the query by adding the clause “FROM iq_dummy,” where iq_dummy is a one-row, one-column table that you create in your database.