Default Option Management

Options can be handy for controlling the Data Virtuality Server behaviour, and the CData Virtuality Server has several stored procedures for handling default option values. On this page, we give information on these procedures; for detailed information on each option, please refer to this section.

SYSADMIN.setDefaultOptionValue

This procedure writes a default option:

SQL

SYSADMIN.setDefaultOptionValue(IN opt string NOT NULL, IN val string, IN encVal string)

Example

SQL

CALL "SYSADMIN.setDefaultOptionValue"( 'ALLOW_CARTESIAN', 'ALWAYS' );;
CALL "SYSADMIN.setDefaultOptionValue"("opt" => 'DV_AUTH_LOAD_USERS', "val" => true);;
CALL "SYSADMIN.setDefaultOptionValue"("opt" => 'DV_AUTH_CLIENT_ID', "encVal" => 'clientID');;

Parameters

Parameter	Description
`opt`	Option name
`val`	Option value
`encVal`	Encrypted option value (applicable to some specific options)

Encrypted option values are available since v4.5

SYSADMIN.getDefaultOptionValue

This option gets the value for the specified option:

SQL

SYSADMIN.getDefaultOptionValue( <optionname> )

Example

SQL

CALL SYSADMIN.getDefaultOptionValue( 'ALLOW_CARTESIAN' )

For both setDefaultOptionValue() and getDefaultOptionValue(), <optionname> should be passed without the dollar sign ($).

Setting a Default Option to its Default Value

A default option can be reset to its default value by providing an empty string as a value:

SQL

SYSADMIN.setDefaultOptionValue( <optionname>, '' )

Example

SQL

CALL SYSADMIN.setDefaultOptionValue( 'ALLOW_CARTESIAN', '' )