This appendix describes the Standard Catalog Interface catalogs, the Extended System catalogs, and the DBMS System Catalogs.
If you are developing applications that need to query the system catalogs, you must use the Standard Catalog Interface, so that your applications will be upwardly compatible.
The Standard Catalog Interface described in this appendix corresponds to the formats you find when the iidbcapabilities catalog contains the following values:
CAP_CAPABILITY |
CAP_VALUE |
|---|---|
STANDARD_CATALOG_LEVEL |
00904 |
The DBMS System Catalogs and Extended System Catalogs are unsupported and can change at any time. Information about these catalogs is provided solely for your convenience. In providing this information, the company makes no commitment to maintain compatibility with any feature, tool, or interface. The company does not provide support, either through customer support or release maintenance channels, for the resolution of any problems or bugs arising from the use of unsupported features, tools, or interfaces.
|
|
|
System catalogs are tables that store information required by Ingres. These catalogs can be used in programs to access (but not update) information about the system.
Unless otherwise noted, values in system catalogs are leftjustified, and columns are non-nullable.
The length of char fields, as listed in the Data Type column, is a maximum length; the actual length of the field is installation-dependent. When developing applications that access these catalogs, you must allocate storage on the basis of the length as shown in the Data Type column.
All dates stored in system catalogs have the following format (underscores and colons are required):
yyyy_mm_dd hh:mm:ss GMT (Greenwich Mean Time)
To display the format of catalogs, use the help table statement.