Was this helpful?
iidbcapabilities Catalog
The iidbcapabilities catalog contains information about the capabilities provided by the Enterprise Access product or Ingres DBMS. The following table describes the columns in the iidbcapabilities catalog:
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.
cap_capability Column
The cap_capability column in the iidbcapabilities catalog contains one or more of the following values:
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.
Last modified date: 12/14/2023