Configuring Options

You are looking at an older version of the documentation. The latest version is found here.

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`
`AUTO_ADD_COLUMN`
`CLEANER_DAYS_TO_KEEP`
`CLEANER_STAGES_TO_KEEP`
`DATA_TRANSFER_MODE`
`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`
`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`

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, and SKIP_STRUCTURE_CHECKING changed via setDefaultOptionValue will affect the Data Virtuality Server behaviour immediately. All other default option values changed via setDefaultOptionValue will affect the Data 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.