The server_info Information Schema View

The server_info Information Schema view describes the database server to which the application is currently connected. It contains two columns.


Column	Data Type	Explanation
server_attribute	VARCHAR(254)	An attribute of the database server
attribute_value	VARCHAR(254)	Value of the server_attribute as it applies to the current database server

Each row in this view provides information about one attribute. X/Open-compliant databases must provide applications with certain required information about the database server.

The server_info view includes the following server_attribute information.


server_attribute	Explanation
identifier_length	Maximum number of bytes for a user-defined identifier
row_length	Maximum number of bytes in a row
userid_length	Maximum number of bytes in a user name
txn_isolation	Initial transaction isolation level for the database server: `Read Uncommitted` ( = Default isolation level for databases with no transaction logging; also called `Dirty Read`) `Read Committed` ( = Default isolation level for databases that are not ANSI-compliant, but that support explicit transaction logging) `Serializable` ( = Default isolation level for ANSI-compliant databases; also called`Repeatable Read)`
collation_seq	Assumed ordering of the character set for the database server The following values are possible: `ISO 8859-1` `EBCDIC` The default HCL OneDB™ representation shows ISO 8859-1.

The server_info view is completely visible to all users.