The SYSCATALOGS view contains one row for each relational database that a
user can connect to. The following table describes the columns in the
SYSCATALOGS view.
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
CATALOG_NAME | LOCATION | VARCHAR(18) | Relational database name. |
CATALOG_STATUS | RDBASPSTAT | CHAR(10) | Status of a relational database.
|
CATALOG_TYPE | RDBTYPE | CHAR(7) | Relational database type.
|
CATALOG_ASPGRP | RDBASPGRP | VARCHAR(10)
Nullable | Independent auxiliary storage pool (IASP) name.
Contains the null value if the relational database status is UNKNOWN. |
CATALOG_ASPNUM | RDBASPNUM | VARCHAR(10)
Nullable | Independent auxiliary storage pool (IASP) number.
Contains the null value if the relational database status is UNKNOWN. |
CATALOG_TEXT | RDBTEXT | CHAR(50) | Relational database text description. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.