SYSDUMMY1 catalog table

The SYSDUMMY1 catalog 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 most other catalog tables, which reside in Unicode table spaces, the SYSIBM.SYSDUMMY1 table resides in the SYSEBCDC table space, which is defined with the EBCDIC encoding scheme.

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