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:
SYSADMIN.setDefaultOptionValue(IN opt string NOT NULL, IN val string, IN encVal string)
Example
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 |
---|---|
val | Option value |
opt | Option name |
encVal | Encrypted option value (applicable to some specific options) |
SYSADMIN.getDefaultOptionValue
This option gets the value for the specified option:
SYSADMIN.getDefaultOptionValue( <optionname> )
Example
CALL SYSADMIN.getDefaultOptionValue( 'ALLOW_CARTESIAN' )
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:
SYSADMIN.setDefaultOptionValue( <optionname>, '' )
Example
CALL SYSADMIN.setDefaultOptionValue( 'ALLOW_CARTESIAN', '' )