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.

Column name Data type Description Use
IBMREQD
CHAR(1)
NOT NULL
A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. For all other values, see Release dependency indicators.

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

G