DEE() - Table without columns

Function group: table function

The table function DEE() returns a table without columns with one row.

In SESAM/SQL there are no other tables of this kind. They can, for example, be used to analyze an expression without reference to a base table. No SQL privilege is required for reading with DEE().

---

DEE [()]

---

Result

The table without columns with one row.

Examples

This query returns details of SQL mode:

SELECT CURRENT_USER AS "Who am I", 
       LOCALTIMESTAMP(3) AS "and what time is it, anyway"
   FROM TABLE(DEE())

The following query is executed for database k9 and could return a different time:

SELECT LOCALTIMESTAMP(3) AS "local time on catalog K9"

FROM TABLE(K9.DEE())

The following query expands table T by one row with NULL values:

SELECT * FROM T UNION JOIN TABLE(DEE())