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, 2006. All Rights Reserved.