Skip to main content

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:

  1. Access the Management Portal.

  2. Select System Administration > Configuration > SQL and Object Settings > SQL.

  3. On the SQL page, check or clear the Retain cached query source box, as desired.

  4. Click Save.

For more information, see Cached Queries.

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:

  1. Access the Management Portal.

  2. Select System Administration > Configuration > SQL and Object Settings > SQL.

  3. On the SQL page, edit the Default schema field, as desired.

  4. 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 chapter “Configuring InterSystems IRIS” 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:

For details, see the InterSystems Class Reference for these classes.

For More Information

For more information on the topics covered in this chapter, see the following:

FeedbackOpens in a new tab