Column Name | Data Type | Description |
|---|---|---|
cap_capability | char(32) | Contains one of the values listed in the capability column of the following table. |
cap_value | char(32) | The contents of this field depend on the capability. See the Values column in the following table. |
Capability | Value | ||
|---|---|---|---|
CAP_SLAVE2PC | Indicates if the DBMS supports Ingres two-phase commit slave protocol: Version 6.3 and above: Y Ingres Star: Y Enterprise Access product: usually N | ||
DBEVENTS | Y if the DBMS supports database events, N if not. | ||
DBEVENT_GRANT | Y if DBEvent related grant statements are accepted, N if rejected. | ||
DB_NAME_CASE | Case sensitivity of the database with respect to database object names: LOWER, UPPER, MIXED. Defaults to LOWER. If the value is MIXED, case must be carefully preserved when specifying database objects. This field applies to names of database objects (tables, views, columns, and owners.) Names of user interface objects (such as forms or reports) are always lower case. | ||
DB_DELIMITED_CASE | Case conversion performed by the DBMS for object names specified using delimited identifiers (that is, in double quotes). LOWER if delimited identifiers are translated to lower case, UPPER if delimited identifiers are translated to upper case, or MIXED if no case translation is performed. | ||
DBMS_TYPE | The type of DBMS the application is communicating with. Valid values are the same as those accepted by the WITH DBMS clause used in queries. Examples: INGRES, STAR, RMS. The default value is INGRES. | ||
DISTRIBUTED | Y if the DBMS is distributed, N if not. | ||
ESCAPE | Contains Y if DBMS supports the ESCAPE clause of the LIKE predicate in the WHERE clause of search statements. Contains N if ESCAPE is not supported. | ||
ESCAPE_CHAR | Character used to escape pattern characters in LIKE predicate. | ||
IDENT_CHAR | Characters permitted in non-delimited identifiers beyond alphanumeric and '_'. | ||
INGRES | Set to Y if the DBMS supports all versions of Ingres Release 6 and Ingres Release 1; otherwise N. Default is Y. | ||
INGRES/SQL_LEVEL | Version of Ingres SQL supported by the DBMS. Examples: 00600 = 6.0 00601 = 6.1 00602 = 6.2 00603 = 6.3 00604 = 6.4 00605 = OpenIngres 1.x 00800 = OpenIngres 2.0 and Ingres II 2.0 00850 = Ingres II 2.5 00860 = Ingres 2.6 00902 = Ingres r3 00904 = Ingres 9.0 00910 = Ingres 9.1 00920 = Ingres 9.2 00930 = Ingres 9.3 00000 = DBMS does not support Ingres SQL Default is 00000. | ||
INGRES/QUEL_LEVEL | Version of Ingres QUEL supported by the DBMS. Examples: 00600 = 6.0 00601 = 6.1 00602 = 6.2 00603 = 6.3 00604 = 6.4 00605 = OpenIngres 1.x 00800 = OpenIngres 2.0 and Ingres II 2.0 00850 = Ingres II 2.5 00860 = Ingres 2.6 00902 = Ingres r3 00904 = Ingres 9.0 00910 = Ingres 9.1 00920 = Ingres 9.2 00930 = Ingres 9.3 00000 = Does not support QUEL Default is 00000. | ||
INGRES_AUTH_GROUP | Y if the DBMS supports group identifiers. | ||
INGRES_AUTH_ROLE | Y if the DBMS supports role identifiers. | ||
INGRES_LOGICAL_KEY | Y if the DBMS supports Ingres logical keys. | ||
INGRES_RULES | Y if the DBMS supports Ingres rules; N if it does not. | ||
INGRES_UDT | Y if the DBMS supports Ingres user-defined data types, N if the DBMS does not support user-defined data types. | ||
MAX_COLUMNS | Maximum number of columns allowed in a table. Default is 127. | ||
NATIONAL_CHARACTER_SET | Y if the DBMS supports Unicode, N if it does not. | ||
NULL_SORTING | How NULL values are sorted relative to other values: HIGH NULLS are considered the highest possible value. LOW NULLS are considered the lowest possible value. FIRST NULLs appear at start regardless of ascending/descending. LAST NULLS appear at end regardless of ascending/descending. | ||
OPEN_SQL_DATES | Contains LEVEL 1 if the Enterprise Access product supports the OpenSQL date data type. | ||
OPEN/SQL_LEVEL | Version of OpenSQL supported by the DBMS. Examples: 00600 = 6.0 00601 = 6.1 00602 = 6.2 00603 = 6.3 00604 = 6.4 00605 = OpenIngres 1.x 00800 = OpenIngres 2.0 and Ingres II 2.0 00850 = Ingres II 2.5 00860 = Ingres 2.6 00902 = Ingres r3 00904 = Ingres 9.0 Default is 00602. | ||
OPENSQL_SCALARS | Can be one of three values: 'NATIVE', 'FULL' or LEVEL 1. The default value is 'NATIVE'. 'NATIVE' indicates only native DBMS scalar functions are supported. 'FULL' indicates full Ingres scalar function support is provided. LEVEL 1 indicates some mapping of Ingres scalar functions. When OPENSQL_SCALARS is set to LEVEL 1, an additional table, iigwscalars, is provided which shows support details for individual scalar functions. See iigwscalars Catalog. | ||
OUTER_JOIN | Whether outer joins are supported: N for no, Y for yes. | ||
OWNER_NAME | Contains N if owner.table table name format not supported. Contains Y if owner.table format supported. Contains QUOTED if owner.table supported with optional quotes (“owner”.table). | ||
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. Valid values: 00602 (default) 00604 00605 00800 00850 00860 00902 00904 For catalog formats, see the appendix “System Catalogs” in the Database Administrator Guide. | ||
SQL92_COMPLIANCE | The level of SQL-92 supported: | ||
NONE | SQL-92 Entry level not supported | ||
ENTRY | SQL-92 Entry level | ||
FIPS-IEF | SQL-92 Entry level plus FIPS Integrity Enhancements features | ||
INTERMEDIATE | SQL-92 Intermediate level | ||
FULL | SQL-92 Full level | ||
SQL_MAX_CHAR_COLUMN_LEN | Maximum length of a CHAR column. Permits 0 for unsupported and ‑1 for unknown or unlimited. | ||
SQL_MAX_VCHR_COLUMN_LEN | Maximum length of a VARCHAR column. Permits 0 for unsupported and ‑1 for unknown or unlimited. | ||
SQL_MAX_NCHAR_COLUMN_LEN | Maximum number of characters for an NCHAR column. | ||
SQL_MAX_NVCHR_COLUMN_LEN | Maximum number of characters for an NVARCHAR column. | ||
SQL_MAX_BYTE_COLUMN_LEN | Maximum length of a BYTE column. Permits 0 for unsupported and ‑1 for unknown or unlimited. | ||
SQL_MAX_VBYT_COLUMN_LEN | Maximum length of a VARBYTE column. Permits 0 for unsupported and ‑1 for unknown or unlimited. | ||
SQL_MAX_CHAR_LITERAL_LEN | Maximum length of a string literal. Permits 0 for unsupported and ‑1 for unknown or unlimited. | ||
SQL_MAX_BYTE_LITERAL_LEN | Maximum length of a hex literal. Permits 0 for unsupported and ‑1 for unknown or unlimited. | ||
SQL_MAX_USER_NAME_LEN | Maximum length of a user name. Permits 0 for unsupported and ‑1 for unknown or unlimited. | ||
SQL_MAX_ROW_LEN | Maximum length of a row. Permits 0 for unsupported and ‑1 for unknown or unlimited. | ||
SQL_MAX_STATEMENTS | Maximum number of active (prepared) statements. Permits 0 for unsupported and ‑1 for unknown or unlimited. | ||
UNION | Whether UNION selects are supported: | ||
N | No | ||
Y | Yes | ||
ALL | Yes and UNION ALL. | ||
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. | ||