DB2: The Real use of SYSDUMMY1 Table

The DB2 SYSIBM.SYSDUMMY1 table contains one row. The purpose of it is, 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

DB2 Sysdumm1 Table.

S.NOData Type
1Char (01)
Sysdummy1 Table


Get new content delivered directly to your inbox.

Author: Srini

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