GET_SERVER_CFG¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

This command, when passed a valid server name, returns the a value for the specified attribute.

Syntax

GET_SERVER_CFG {constant} of {server} to {variable}

Parameter

Description

constant

constant of the attibute to retrieve (see list below)

variable

Variable to hold the return value - varies, see list below

Allowed constants

  • SERVER_REVISION Returns the major version, to the left of the decimal, of the server

  • SERVER_MIN_REVISION Returns the minor version, to the right of the decimal, of the server

  • SUPPORT_DESC Returns 1 if Server supports descending index segments

  • SUPPORT_CASE Returns 1 if Server supports case insensitive index segments

  • SERVER_VERSION Returns the full version of the server

  • SERVER_ENCODING Returns the Server Encoding Only applicable to PostgreSQL and Oracle servers

  • CONNECTION_ACTIVE Returns 1 if the connection to the server is active

  • CITEXT_SUPPORT Returns 1 if Server supports citext, a PostgreSQL data type Only applicable to PostgreSQL servers

Example

string sVersion

GET_SERVER_CFG SERVER_VERSION of "MYSERVER" to sVersion