System table name

[never]

Hi all,
sorry to disturbing all but...Can somebody to help me!!
I need write script for DB2 but I haven't access now to this DB that I look for this trivial problem.
So..I need find out name of system table where is stored names of all schema. In the concrete i need show all name of tables in some schema.

THX a lot
Never

 

[Crox]

Hi,

get the manuals from IBM.

Look at IBM's bookmanager. Look for DB2 SQLguide and SQL reference.

Try this link:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/FINDBOOK?filter=db2&Collection=0

Lots of luck!

Regards,

Crox

 

[never]

THX Crox

 

[vtj]

Try this in SQL:

SELECT SYSTEM_TABLE_NAME, SYSTEM_TABLE_SCHEMA
FROM SYSTABLES

SYSTABLES is a view supplied by IBM. Its library is SYSIBM.

Hope this helps.

vtj

 

[spine]

You can get schemas and associated tablenames with this SQL.

SELECT tabschema, tabname
FROM sysstat.tables