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.
Use of SYSDUMM1 Table
In DB2, the dummy table is SYSDUMMY1. You can use dummy table to know DATE, TIME and Current version of DB2.
Unlike the other catalog tables, which reside in Unicode table spaces, SYSIBM.SYSDUMMY1 resides in table space SYSEBCDC, which is an EBCDIC table space. Complete DB2 Course to Learn Quickly.
Next step to improve DB2 skills
SQL and DB2 Skills Make You King in your Current or Future Projects
|Column name||Data type||Description||Use|
|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|
- Read on online with an example how to use Sysdummy1