Skip to main content
Skip table of contents

Default Option Management

Options can be handy for controlling the Data Virtuality Server behaviour, and the Data Virtuality Server has several stored procedures for handling default option values. On this page, we give information on these procedures.

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

ParameterDescription
valOption value
optOption name
encValEncrypted option value (applicable to some specific options)

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', '' )
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.