ANS and ISO catalog views
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 |
|---|---|---|
| AUTHORIZATIONS | Information about authorization IDs | |
| CHARACTER_SETS | CHARACTER_SETS_S | Information about supported CCSIDs |
| CHECK_CONSTRAINTS | Information about check constraints | |
| COLUMN_PRIVILEGES | Information about column privileges | |
| 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 |
| ROUTINE_PRIVILEGES | RTNPRIV | Information about routine privileges |
| ROUTINES | ROUTINES_S | Information about routines |
| SCHEMATA | SCHEMATA_S | Statistical information about schemas |
| SEQUENCES | Information about sequences | |
| TABLE_CONSTRAINTS | Information about constraints | |
| TABLE_PRIVILEGES | Information about table privileges | |
| TABLES | TABLES_S | Information about tables |
| UDT_PRIVILEGES | UDTPRIV | Information about type privileges |
| USAGE_PRIVILEGES | USAGEPRIV | Information about sequence and XML schema privileges |
| USER_DEFINED_TYPES | UDT_S | Information about types |
| VARIABLE_PRIVILEGES | VARPRIV | Information about global variable privileges |
| VIEWS | Information about views |