DUMMY System Table

The DUMMY 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

The DUMMY table is a SQL Anywhere system table. See SQL Anywhere 11.0.1 > SQL Anywhere Server - SQL Reference > System Objects > Tables > System tables > DUMMY system table.

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

CREATE TABLE iq_dummy (dummy_col INT NOT NULL);

and use this table explicitly:

SELECT NOW() FROM iq_dummy;