SYS.DUMMY Table Versus IQ

The DUMMY system table is provided as a table that always has exactly one row.

This can be useful for extracting information from the database, as in the following example that gets the current user ID and the current date from the database

SELECT USER, today(*) FROM SYS.DUMMY

Queries using the DUMMY table are run by SQL Anywhere (the catalog store), rather than by SAP Sybase IQ. You can create a dummy table in the SAP Sybase IQ database. For example:

CREATE TABLE iq_dummy (dummy_col INT NOT NULL);

and use this table explicitly:

SELECT NOW() FROM iq_dummy;

SYS.DUMMY Table Versus IQ_DUMMY Table