If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Views are also included in syscat.tables, so if you only want real tables, check the TYPE column. The meaning of the columns in the catalog tables are defined in the appendix of the SQL Reference, Vol 1, which can be downloaded in PDF format at no charge at the IBM website (see Useful DB2 Stuff thread above).