"Philip Sherman" <ps******@ameritech.net> wrote in message
news:Vq******************@newssvr17.news.prodigy.c om...
I'm not sure about MVS but on LUW; SYSIBM.SYSDUMMY1 IS NOT A TABLE.
I can't speak for V8.x of DB2 for Linux/Unix/Windows but in V7.2 of LUW,
Appendix D (Catalog Views) of the SQL Reference index lists SYSIBM.SYSDUMMY1
at the very start of the list of Catalog Views. According to the actual
article referenced by the link:
----
SYSIBM.SYSDUMMY1
Contains one row. This view is available for applications that require
compatibility with DB2 Universal Database for OS/390.
Table 41. SYSCAT.DUMMY1 Catalog View
Column Name Data Type Nullable Description
IBMREQD CHAR(1)
Y
----
When I look at the Sample database in the Control Center, SYSIBM.SYSDUMMY1
is *not* visible in the Tables list even the other SYSIBM.* tables are.
Also, SYSCAT.DUMMY1 is *not* visible in the Views list either.
However, when I do a SELECT * on SYSIBM.SYSDUMMY1 in the Command Center, the
query works fine and shows the single row in the table. When I do a SELECT *
on SYSCAT.DUMMY1, I get an SQL0204N error that says "SYSCAT.DUMMY1" is an
undefined name.
The documentation, the Control Center, and the Command Center are not very
consistent with respect to this table, I must say!
Rhino