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 The iigwscalars Catalog (see page The 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.