Column Name | Data Type | Description |
|---|---|---|
cap_capability | char(32) | Contains one of the values listed in the Capability column of the following table. If the cap_capability has a value, it will be activated by the value in the cap_value column. |
Cap_value | char(32) | Set to the value of the capability. This is usually the string Y or N. See the Values column in the following table for possible values of each capability. |
Capability | Value |
|---|---|
OPEN/SQL_LEVEL | Version of OpenSQL supported by the DBMS. Use this name in preference to the older COMMON/SQL_LEVEL. Default setting is 00605. |
COMMON/SQL_LEVEL | Version of OPEN/SQL support provided by the DBMS. Maintained for backward compatibility. (Use OPEN/SQL_LEVEL instead.) Examples: 00600 Version 6.0 00601 Version 6.1 00602 Version 6.2 Default is 00600. |
DB_NAME_CASE | Case mapping semantics of the database with respect to regular identifiers for database objects: LOWER for lowercase is the Ingres setting. UPPER for uppercase is set for an ISO Entry SQL92 compliant installation. |
DB_DELIMITED_CASE | Case mapping semantics of the database with respect to delimited identifiers for database objects: LOWER for lowercase is the Ingres setting. MIXED for mixed case is set for an ISO Entry SQL92 compliant installation. If the value is MIXED, an identifier must be enclosed in double quotes to maintain case as originally defined. Otherwise it is treated as a regular identifier (converted to uppercase). |
DB_REAL_USER_CASE | Case mapping of user names as retrieved by the operating system: LOWER for lowercase is the Ingres setting. MIXED for mixed case or UPPER for uppercase is set as specified during installation. |
DBMS_TYPE | The type of DBMS the application is communicating with. For a Star Server, the value is always STAR. |
DISTRIBUTED | Y since the DBMS is distributed. |
INGRES | Set to Y if the DBMS supports in all respects 100 percent of Ingres Release 6. Otherwise N. For Ingres Star this is set to N since it does not support QUEL. |
INGRES/SQL_LEVEL | Version of SQL supported by the DBMS. These include: 00600 Version 6.0 00601 Version 6.1 00602 Version 6.2 00603 Version 6.3 00604 Version 6.4 00605 Ingres 00000 DBMS does not support SQL Default is 00600. |
INGRES/QUEL_LEVEL | Version of QUEL supported by the DBMS. These include: 00600 Version 6.0 00601 Version 6.1 00602 Version 6.2 00603 Version 6.3 00604 Version 6.4 00605 Ingres 00000 DBMS does not support QUEL Default is 00600. |
OWNER_NAME | Contains N if schema.table table name format is not supported. Contains Y if schema.table format is supported; contains QUOTED if schema.table is supported with optional quotes (“schema”.table). The default is QUOTED. |
PHYSICAL_SOURCE | T indicates that both iitables and iiphysical_tables contain physical table information. P indicates that only iiphysical_tables contains the physical table information. |
SAVEPOINTS | Y if savepoints behave exactly as in Ingres, else N. Default is Y. |
STANDARD_CATALOG _LEVEL | Version of the standard catalog interface supported by this database. Should be 00602 (the default) for Ingres Star. |
UNIQUE_KEY_REQ | Set to Y if the database service requires that some or all tables have a unique key. Set to N or not present if the database service allows tables without unique keys. |