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.
|