How “SYSIBM.SYSDUMMY1” different from other catalog tables

The SYSIBM.SYSDUMMY1 table contains one row. The table is used for SQL statements in which a table reference is required, but the contents of the table are not important. You will get DB2 version from SYSDUMMY1 table. Read here.

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.

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

G

Ref:IBM manuals

You can read online an example how to use Sysdummy1

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.