Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


SERVER_INFO


The SERVER_INFO system view lists the attributes of the database server to which the application is currently connected.

Each row provides information about one attribute. The attribute is identified in the SERVER_ATTRIBUTE column and the value of the attribute for the current server is shown in the ATTRIBUTE_VALUE column.

Column name
Data type
Description
SERVER_ATTRIBUTE
VARCHAR(254)
The name of the server attribute. One of:
CATALOG_NAME
COLLATION_SEQ
IDENTIFIER_LENGTH
INTERVAL_FRACTIONAL
_PRECISION
INTERVAL_LEADING
_PRECISION
ROW_LENGTH
TIME_PRECISION
TIMESTAMP_PRECISION
TXN_ISOLATION
USERID_LENGTH
ATTRIBUTE_VALUE
VARCHAR(254)
The value of the corresponding server attribute.
For CATALOG_NAME:
"YES" = the server supports catalog names, otherwise
"NO".
For COLLATION_SEQ: either "ISO 8859-1" or "EBCDIC" to indicate the assumed ordering of the character set for the server.
For IDENTIFIER_LENGTH: the maximum number of characters allowed for a user-defined name, shown as the character string representation of the decimal value.
For INTERVAL_FRACTIONAL_PRECISION: the default seconds precision for all interval data types with a seconds component.
For INTERVAL_LEADING_PRECISION: the default leading precision for all intervals.
For ROW_LENGTH: the maximum size of a row, shown as the character string representation of the decimal value.
For TIME_PRECISION: the default seconds precision for all objects of data type TIME.
For TIMESTAMP_PRECISION: the default seconds precision for all objects of data type TIMESTAMP.
For TXN_ISOLATION: the initial transaction isolation level assumed by the server. One of:
READ UNCOMMITTED
READ COMMITTED
REPEATABLE READ
SERIALIZABLE.
For USERID_LENGTH: the maximum number of characters of a user name (or "authorization identifier"), shown as the character string representation of the decimal value.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX