Accessing db2 catalog tables

RudiVdm · #1 (**permalink**) 01-22-04, 05:24

Hi

Simple question ...
I need to access SYSCAT>VIEWS ... and this doesn't work :
SELECT * FROM SYSCAT.VIEWS

How should I access the contents of that table?

Thanks

RudiVdm · #2 (**permalink**) 01-22-04, 05:42

I get 'Invalid object 'VIEWS'

sathyaram_s · #3 (**permalink**) 01-22-04, 06:26

Assume you are NOT using Unix or Windows version of db2

RudiVdm · #4 (**permalink**) 01-23-04, 02:57

No, neither. Using OS2 I think, standard AS/400 operating system.

Marcus_A · #5 (**permalink**) 01-23-04, 05:22

OS/2 and AS/400 are completely different operating systems.

Find the SQL Reference manual for your platform and look in the Appendix for Catalog Tables or Catalog Views. On some platforms (like mainframe) it would be called sysibm.systables with a "V" in the TYPE column.

On Linux, UNIX, and Windows (and older DB2 versions that supported OS/2) you can query syscat.tables with with a "V" in the TYPE column. or you can query sycat.views.