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.
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.
To change this setting:
-
Log into the Management Portal.
-
Select System Administration > Configuration > SQL and Object Settings > SQL.
-
On the SQL page, check or clear the Retain cached query source box, as desired.
-
Click Save.
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.
To change this setting:
-
Log into the Management Portal.
-
Select System Administration > Configuration > SQL and Object Settings > SQL.
-
On the SQL page, edit the Default schema field, as desired.
-
Click Save.
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® 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 in the System Administration Guide.
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.
For More Information
For more information on the topics covered in this page, see the following:
-
System Administration Guide describes how to use most of the Management Portal.
-
The InterSystems Class Reference provides details on all non-internal classes provided with InterSystems IRIS.
-
Configuration Parameter File Reference contains reference information on the CPF.
