Displaying Db2 Table Descriptions

Descriptions of Db2 tables used by ChangeMan ZMF ERO are not included in this manual. Use the following SPUFI SQL to display ERO Db2 table descriptions:

SELECT  NAME,
        COLTYPE,
        LENGTH,
        REMARKS
FROM    SYSIBM.SYSCOLUMNS
WHERE   TBCREATOR   = 'CMNx'
AND     TBNAME      = 'CMNRLSIAT'
;

In this example, x is the one-character subsystem ID of the SERNET started task for which table CMNRLSIAT was defined.

ERO Db2 tables include:

Release Management Tables
CMNRLSHST	Component History Table
CMNRLSCIM	Component in Motion Table
CMNRLSIAT	Release Impact Analysis Table

...