There are two versions of some of the ANS and ISO catalog views. The version documented is the normal set of ANS and ISO views. A second set of views have names that are limited to no more than 18 characters and other than the view names are not documented in this book.
The ANS and ISO catalog includes the following tables in the QSYS2 library:
View Name | Shorter View Name | Description |
---|---|---|
SQL_FEATURES | Information about features supported by the database manager | |
SQL_LANGUAGES | SQL_LANGUAGES_S | Information about the supported languages |
SQL_SIZING | Information about the limits supported by the database manager |
The ANS and ISO catalog includes the following views and tables in the SYSIBM and QSYS2 libraries:
View Name | Shorter View Name | Description |
---|---|---|
CHARACTER_SETS | CHARACTER_SETS_S | Information about supported CCSIDs |
CHECK_CONSTRAINTS | Information about check constraints | |
COLUMNS | COLUMNS_S | Information about columns |
INFORMATION_SCHEMA_CATALOG_NAME | CATALOG_NAME | Information about the relational database |
PARAMETERS | PARAMETERS_S | Information about procedure parameters |
REFERENTIAL_CONSTRAINTS | REF_CONSTRAINTS | Information about referential constraints |
ROUTINES | ROUTINES_S | Information about routines |
SCHEMATA | SCHEMATA_S | Statistical information about schemas |
TABLE_CONSTRAINTS | Information about constraints | |
TABLES | TABLES_S | Information about tables |
USER_DEFINED_TYPES | UDT_S | Information about distinct types |
VIEWS | Information about views |
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.