SYSDUMMY1 catalog table

The SYSDUMMY1catalog 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.

Unlike the other catalog tables, which reside in Unicode table spaces, SYSIBM.SYSDUMMY1 resides in table space SYSEBCDC, which is an EBCDIC table space.

Table 1. SYSIBM.SYSDUMMY1 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