Column Name | Data Type | Description |
cap_capability | char(32) | Contains one of the values listed in the capability column of the table below. |
cap_value | char(32) | The contents of this field depend on the capability; see the Value column in the table below. |
Capability | Value |
COMMON/SQL_LEVEL | Deprecated. Use OPEN/SQL_LEVEL |
DB_DELIMITED_CASE | The case of delimited identifiers: LOWER for lowercase (Ingres setting) MIXED for mixed case (ISO Entry SQL92 setting) If MIXED, an identifier must be enclosed in double quotes to maintain its original case; otherwise, it is converted to uppercase. |
DB_NAME_CASE | The case of regular identifiers: LOWER for lowercase (Ingres setting) UPPER for uppercase (ISO Entry SQL92 setting) |
DB_REAL_USER_CASE | The case of user names as retrieved by the operating system. LOWER for lowercase (Ingres setting) MIXED for mixed case UPPER for uppercase |
DBMS_TYPE | The type of DBMS the application is communicating with. Valid values are the same as those accepted by the WITH DBMS = clause. Examples: INGRES (default) INGRES_VECTORWISE STAR RMS |
DISTRIBUTED | Y if the database is distributed N if database is local |
ESCAPE | Y if DBMS supports the ESCAPE clause of the LIKE predicate in the WHERE clause N if ESCAPE is not supported |
INGRES | Y if the DBMS supports all aspects of Release 6 and Ingres (the default) N if not |
INGRES/SQL_LEVEL | Version of SQL supported by the DBMS Examples: 00604 6.4 00605 OpenIngres1.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 01000 Ingres 10.0 01010 Ingres 10.1 00000 DBMS does not support SQL |
INGRES/QUEL_LEVEL | Version of QUEL supported by the DBMS Examples are the same as for INGRES/SQL_LEVEL. |
INGRES_RULES | Y if rules supported N if rules not supported |
INGRES_UDT | Y if user-defined data types supported N if user-defined data types not supported |
INGRES_AUTH_GROUP | Y if group identifiers supported N if group identifiers not supported |
INGRES_AUTH_ROLE | Y if role identifiers supported N if role identifiers not supported |
INGRES_LOGICAL_KEY | Y if logical keys supported N if logical keys not supported |
MAX_COLUMNS | Maximum number of columns allowed in a table. |
MIXEDCASE_NAMES | Y if case is significant in object names. N if ABC, Abc, and abc are all equivalent object names. |
NATIONAL_CHARACTER_ SET | Y if Unicode supported N if Unicode not supported |
OPEN_SQL_DATES | Contains LEVEL 1 if the Enterprise Access Server supports the OpenSQL date data type. Absent if OpenSQL date data type is implicitly supported when accessing a standard DBMS server. |
OPEN/SQL_LEVEL | Version of OpenSQL supported by the DBMS Examples: 00860 Ingres 2.6 00902 Ingres r3 00904 Ingres 9.0 Use this name instead of the deprecated COMMON/SQL_LEVEL. |
OWNER_NAME | schema.table format is supported with with optional quotes. The default is QUOTED. |
PHYSICAL_SOURCE | T indicates that iitables contains physical table information. P (a deprecated setting) indicates that only iiphysical_tables contains the physical table information. T is the default and only current usage. |
QUEL_LEVEL | Text version of QUEL support level. Example: II10.1.0 |
SAVEPOINTS | Y if savepoints behave exactly as in Ingres (default) N if not |
SLAVE2PC | Indicates if the DBMS supports Ingres 2-phase commit slave protocol: Y for Release 6.3 and above N for Star N usually for Enterprise Access If not present, Y is assumed. |
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_LEVEL | Text version of SQL support level. |
STANDARD_CATALOG_ LEVEL | Release of the standard catalog interface supported by this database. Examples: 00602 00604 00605 00800 00850 00860 00902 00904 00920 00930 01000 |
UNIQUE_KEY_REQ | Y if the database service requires that some or all tables have a unique key. N or not present if the database service allows tables without unique keys. |
SQL_MAX_BYTE_COLUMN_LEN | Maximum number of characters for a BYTE column |
SQL_MAX_BYTE_LITERAL_LEN | Maximum number of characters for a BYTE LITERAL column |
SQL_MAX_CHAR_COLUMN_LEN | Maximum number of characters for a CHAR column |
SQL_MAX_CHAR_LITERAL_LEN | Maximum number of characters for a CHAR LITERAL column |
SQL_MAX_COLUMN_NAME_LEN | Maximum number of characters for a column name |
SQL_MAX_DECIMAL_PRECISION | Maximum decimal precision |
SQL_MAX_PROCEDURE_NAME_LEN | Maximum number of characters for a procedure name |
SQL_MAX_ROW_LEN | Maximum length of a row |
SQL_MAX_SCHEMA_NAME_LEN | Maximum number of characters for a schema name |
SQL_MAX_STATEMENTS | Maximum number of SQL statements If 0 unlimited |
SQL_MAX_TABLE_NAME_LEN | Maximum number of characters for a table name |
SQL_MAX_USER_NAME_LEN | Maximum number of characters for a user name - 32 |
SQL_MAX_VBYT_COLUMN_LEN | Maximum number of characters for a VARBYTE column - 32000 |
SQL_MAX_VCHR_COLUMN_LEN | Maximum number of characters for a VARCHAR column - 32000 |