Server Configuration Options
There are a few configuration options for the server that can affect how you write your code.
Most of the configuration details are saved in a file called iris.cpf (the configuration parameter file or CPF).
Settings for InterSystems SQL
This section discusses some of the most important settings that affect the behavior of InterSystems SQL.
Adaptive Mode
This setting (which is on by default) ensures the best out-of-the-box performance for a wide set of use cases. Specifically, Adaptive Mode controls Runtime Plan Choice (RTPC), parallel processing, and automatically runs TUNE TABLE to optimize the efficiency of query execution. The individual features that Adaptive Mode governs cannot be controlled independently without turning Adaptive Mode off.
For details, see AdaptiveMode in the Configuration Parameter File Reference.
Retain Cached Query Source
This setting specifies whether to save the routine and INT code that InterSystems IRIS generates when you execute any InterSystems SQL except for embedded SQL. In all cases, the generated OBJ is kept. By default, the routine and INT code is not kept.
The query results are not stored in the cache.
For details, see SaveMAC in the Configuration Parameter File Reference.
Default Schema
This setting specifies the default schema name to use when creating or deleting tables that do not have a specified schema. It is also used for other DDL operations, such as creating or deleting a view, trigger, or stored procedure.
For details, see DefaultSchema in the Configuration Parameter File Reference.
For more information, see Schema Name.
Delimited Identifier Support
This setting controls how InterSystems SQL treats characters contained within a pair of double quotes.
If you enable support for delimited identifiers (the default), you can use double quotes around the names of fields, which enables you to refer to fields whose names are not regular identifiers. Such fields might, for example, use SQL reserved words as names.
If you disable support for delimited identifiers, characters within double quotes are treated as string literals, and it is not possible to refer to fields whose names are not regular identifiers.
You can set delimited identifier support system-wide using the SET OPTION command with the SUPPORT_DELIMITED_IDENTIFIERS keyword or by using the $SYSTEM.SQL.Util.SetOption()Opens in a new tab method DelimitedIdentifiers option. To determine the current setting, call $SYSTEM.SQL.CurrentSettings()Opens in a new tab.
For more information, see Delimited Identifiers.
Use of IPv6 Addressing
InterSystems IRIS® data platform always accepts IPv4 addresses and DNS forms of addressing (host names, with or without domain qualifiers). You can configure InterSystems IRIS to also accept IPv6 addresses; see IPv6 Support.
Configuring a Server Programmatically
You can programmatically change some of the operational parameters of InterSystems IRIS by invoking specific utilities; this is how you would likely change the configuration for your customers. For example:
-
Config.MiscellaneousOpens in a new tab includes methods to set system-wide default and settings.
-
%SYSTEM.ProcessOpens in a new tab includes methods to set environment values for the life of the current process.
-
%SYSTEM.SQLOpens in a new tab includes methods for changing SQL settings.
For details, see the InterSystems Class Reference for these classes.
