SYSDUMMYE catalog table

The SYSDUMMYE table contains one row. It is used for SQL statements in which a table reference is required, but the contents of the table are not important. The schema is SYSIBM.

SYSIBM.SYSDUMMYE resides in table space SYSEBCDC, which is a EBCDIC table space.

Table 1. SYSIBM.SYSDUMMYE table column descriptions
Column name Data type Description Use
IBMREQD
CHAR(1)
NOT NULL
A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies.

G