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.

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