Retro Eye care Haitian Deep Dark Default

SET DIST VARIABLE

SET DIST VARIABLE

Description

The SET DIST VARIABLE syntax is used to set system variables.

Syntax

SetDistVariable ::=
  'SET' 'DIST' 'VARIABLE' (proxyPropertyName '=' proxyPropertyValue | 'transaction_type' '=' transactionType | 'agent_plugins_enable' '=' agentPluginsEnable)

proxyPropertyName ::= 
  identifier

proxyPropertyValue ::=
  literal

transactionType ::=
  string

agentPluginsEnable ::=
  boolean

Supplement

proxy_property_name is one of properties configuration of PROXY, name is split by underscore
transaction_type is use to set transaction types for current connection, supports LOCAL, XA, BASE
agent_plugins_enable is use to set the agent plugins enable status, the default value is FALSE
system_log_level is the system log level, only affects the log printing of PROXY, the default value is INFO

Example

Set property configuration of Proxy

SET DIST VARIABLE sql_show = true;

Set transaction type for current connection

SET DIST VARIABLE transaction_type = “XA”;

Set agent plugin enable status

SET DIST VARIABLE agent_plugins_enabled = TRUE;

Reserved word

SET, DIST, VARIABLE

Reserved word