IBM AS400 DB2 Catalog Views
Posted 11-29-2012 at 08:57 AM by NullTerminator
Various objects are available to query the underlying meta data.
select * from qsys2.sysviews where view_owner ='xyz' and TABLE_NAME = 'tab1'
select * from qsys2.systables where table_owner ='xyz' and TABLE_NAME NOT LIKE 'SYS%'
-- Stored Procedures, SIMILAR RESULTS from sysroutines
select * from qsys2.sysprocs where routine_schema ='xyz' and ROUTINE_NAME NOT LIKE 'SYS%'
Other catalog views
SYSINDEXES
SYSKEYS
SYSPROCS
SYSROUTINES
SYSTRIGGERS
THERE ARE ALSO ANUMBER OF VIEWS UNDER
SYSIBM.VIEWS
SYSIBM.SCHEMATA_S
SYSIBM.AUTHORIZATIONS
but I am not so certain of their usefulness
self search CatalogQueries.sql possibly from custrolo
select * from qsys2.sysviews where view_owner ='xyz' and TABLE_NAME = 'tab1'
select * from qsys2.systables where table_owner ='xyz' and TABLE_NAME NOT LIKE 'SYS%'
-- Stored Procedures, SIMILAR RESULTS from sysroutines
select * from qsys2.sysprocs where routine_schema ='xyz' and ROUTINE_NAME NOT LIKE 'SYS%'
Other catalog views
SYSINDEXES
SYSKEYS
SYSPROCS
SYSROUTINES
SYSTRIGGERS
THERE ARE ALSO ANUMBER OF VIEWS UNDER
SYSIBM.VIEWS
SYSIBM.SCHEMATA_S
SYSIBM.AUTHORIZATIONS
but I am not so certain of their usefulness
self search CatalogQueries.sql possibly from custrolo
Total Comments 0