A. System Catalogs : Standard Catalog Interface : Standard Catalogs for All Databases : iidbcapabilities Catalog
 
Share this page                  
iidbcapabilities Catalog
The iidbcapabilities catalog contains information about the capabilities provided by the DBMS.
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.
The cap_capability column contains one or more of the following values:
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