Configuring Options

Options can be configured in an OPTION clause, with the SET statement, and using the setDefaultOptionValue procedure. The table below shows how different values can be set:

Value	`OPTION` clause	`SET` command	`setDefaultOptionValue` procedure
`ALLOW_CARTESIAN`
`ALLOW_INDEX_CREATION`
`ALLOW_INDEX_RECOMMENDATION`
`ALLOW_MAT_AGGR`
`ALLOW_MAT_JOIN`
`ALLOW_XML_TEXT_NODE_WHITESPACE`
`ALLOW_MULTIPLE_UNDERSCORES_IN_COLUMN_NAMES`
`AUTO_ADD_COLUMN`
`CLEANER_DAYS_TO_KEEP`
`CLEANER_STAGES_TO_KEEP`
`CLOUD_AGENT_CLIENT_API_KEY`
`CLOUD_AGENT_HOST_ADDRESS`
`DATA_TRANSFER_MODE`
`DV_AUTH_CLIENT_ID`
`DV_AUTH_CLIENT_SECRET`
`DV_AUTH_LOAD_ROLES`
`DV_AUTH_LOAD_USERS`
`DV_AUTH_REALM`
`DV_AUTH_SERVER_URL`
`ENABLE_DATA_LINEAGE`
`ENABLE_EXPLAIN_LOG_OUTPUT`
`ENABLE_PERFORMANCE_MONITORING`
`JOB_RUN_TIMEOUT`
`MAINTENANCE`
`MAKEDEP`
`MAKENOTDEP`
`MAX_AUTO_INDEXES_PER_TABLE`
`MAX_DECODER_OBJECT_SIZE`
`MAX_JOB_QUEUE_SIZE`
`NAME_RESOLUTION_ORDER`
`NOCACHE`
`NOEXEC`
`NOOPT`
`OLD_PERMISSIONS_BEHAVIOR`
`PASSWORD`
`PREFER_DWH`
`PIPES_PREFER_DROP`
`SHOWPLAN`
`SESSION AUTHORIZATION`
`SKIP_STRUCTURE_CHECKING`
`STORE_QUERY_PLANS`
`TEXT_TABLE_MAX_WIDTH`
`WEB_BUSINESS_DATA_SHOP_EXPORT_FORMATS`
`WEBSERVICE_PUBLIC_URL`
`WS_DATA_RETENTION_PATH`

Default option values can be overridden explicitly by the option clause of a certain query or the SET statement for the current session

Default option value for ALLOW_INDEX_RECOMMENDATION, ALLOW_INDEX_CREATION, ENABLE_EXPLAIN_LOG_OUTPUT, SKIP_STRUCTURE_CHECKING and WS_DATA_RETENTION_PATH changed via setDefaultOptionValue will affect the CData Virtuality Server behaviour immediately. All other default option values changed via setDefaultOptionValue will affect the CData Virtuality Server behaviour for sessions newly opened after the change. To the value of these options for the actual session, you can use the SET statement.

For more information on how to change an option's value using the appropriate method, please refer to the following sections of the Reference Guide:

Default Options for details on using the setDefaultOptionValue procedure;
SET Statement for information on how to change a value using the SET command;
OPTION Clause to know how to use it for changing option values.