The iSeries(TM) catalog includes the following views and tables in the QSYS2 schema:
DB2 UDB for iSeries name | Corresponding ANSI/ISO name | Description |
---|---|---|
SYSCATALOGS | CATALOGS | Information about relational databases |
SYSCHKCST | CHECK_CONSTRAINTS | Information about check constraints |
SYSCOLUMNS | COLUMNS | Information about column attributes |
SYSCST | TABLE_CONSTRAINTS | Information about all constraints |
SYSCSTCOL | CONSTRAINT_COLUMN_USAGE | Information about the columns referenced in a constraint |
SYSCSTDEP | CONSTRAINT_TABLE_USAGE | Information about constraint dependencies on tables |
SYSFUNCS | ROUTINES | Information about user-defined functions |
SYSINDEXES | Information about indexes | |
SYSJARCONTENTS | Information about jars for Java(TM) routines. | |
SYSJAROBJECTS | Information about jars for Java routines. | |
SYSKEYCST | KEY_COLUMN_USAGE | Information about unique, primary, and foreign keys |
SYSKEYS | Information about index keys | |
SYSPACKAGE | Information about packages | |
SYSPARMS | PARAMETERS | Information about routine parameters |
SYSPROCS | ROUTINES | Information about procedures |
SYSREFCST | REFERENTIAL_CONSTRAINTS | Information about referential constraints |
SYSROUTINES | ROUTINES | Information about functions and procedures |
SYSROUTINEDEP | ROUTINE_TABLE_USAGE | Information about function and procedure dependencies |
SYSSEQUENCES | Information about sequences | |
SYSTABLEDEP | Information about materialized query table dependencies | |
SYSTABLES | TABLES | Information about tables and views |
SYSTRIGCOL | TRIGGER_COLUMN_USAGE | Information about columns used in a trigger |
SYSTRIGDEP | TRIGGER_TABLE_USAGE | Information about objects used in a trigger |
SYSTRIGGERS | TRIGGERS | Information about triggers |
SYSTRIGUPD | TRIGGERED_UPDATE_COLUMNS | Information about columns in the WHEN clause of a trigger |
SYSTYPES | USER_DEFINED_TYPES | Information about built-in data types and distinct types |
SYSVIEWDEP | VIEW_TABLE_USAGE | Information about view dependencies on tables |
SYSVIEWS | VIEWS | Information about definition of a view |
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.