DBMS_NAME | string | The name of the database server to which you are
connected. For DB2 servers this is a combination of
DB2 followed by the operating system on which
the database server is running. |
DBMS_VER | string | The version of the database server, in the form of a string
"MM.mm.uuuu" where MM is the major version,
mm is the minor version,
and uuuu is the update. For example, "08.02.0001"
represents major version 8, minor version 2, update 1.
|
DB_CODEPAGE | int | The code page of the database to which you are connected. |
DB_NAME | string | The name of the database to which you are connected. |
DFT_ISOLATION | string | The default transaction isolation level supported by the
server:
- UR
Uncommitted read: changes are immediately visible by all
concurrent transactions.
- CS
Cursor stability: a row read by one transaction can be altered and
committed by a second concurrent transaction.
- RS
Read stability: a transaction can add or remove rows matching a
search condition or a pending transaction.
- RR
Repeatable read: data affected by pending transaction is not
available to other transactions.
- NC
No commit: any changes are visible at the end of a successful
operation. Explicit commits and rollbacks are not allowed.
|
IDENTIFIER_QUOTE_CHAR | string | The character used to delimit an identifier. |
INST_NAME | string | The instance on the database server that contains the
database. |
ISOLATION_OPTION | array | An array of the isolation options supported by the
database server. The isolation options are described in
the DFT_ISOLATION property. |
KEYWORDS | array | An array of the keywords reserved by the database
server. |
LIKE_ESCAPE_CLAUSE | bool | TRUE if the database server supports the
use of % and _ wildcard
characters. FALSE if the database server does not
support these wildcard characters. |
MAX_COL_NAME_LEN | int | Maximum length of a column name supported by the database
server, expressed in bytes. |
MAX_IDENTIFIER_LEN | int | Maximum length of an SQL identifier supported by the database
server, expressed in characters. |
MAX_INDEX_SIZE | int | Maximum size of columns combined in an index supported by the
database server, expressed in bytes. |
MAX_PROC_NAME_LEN | int | Maximum length of a procedure name supported by the database
server, expressed in bytes. |
MAX_ROW_SIZE | int | Maximum length of a row in a base table supported by the
database server, expressed in bytes. |
MAX_SCHEMA_NAME_LEN | int | Maximum length of a schema name supported by the database
server, expressed in bytes. |
MAX_STATEMENT_LEN | int | Maximum length of an SQL statement supported by the database
server, expressed in bytes. |
MAX_TABLE_NAME_LEN | int | Maximum length of a table name supported by the database
server, expressed in bytes. |
NON_NULLABLE_COLUMNS | bool | TRUE if the database server supports columns that can be
defined as NOT NULL, FALSE if the database server does not support
columns defined as NOT NULL. |
PROCEDURES | bool | TRUE if the database server supports the use of the CALL
statement to call stored procedures, FALSE if the database
server does not support the CALL statement. |
SPECIAL_CHARS | string | A string containing all of the characters other than
a-Z, 0-9, and underscore that can be used in an identifier name. |
SQL_CONFORMANCE | string | The level of conformance to the ANSI/ISO SQL-92 specification
offered by the database server:
- ENTRY
Entry-level SQL-92 compliance.
- FIPS127
FIPS-127-2 transitional compliance.
- FULL
Full level SQL-92 compliance.
- INTERMEDIATE
Intermediate level SQL-92 compliance.
|