Server Configuration Options

Copy link to this sectionSettings for InterSystems SQL

To view and modify the settings that affect the behavior of InterSystems SQL:

1. Access the Management Portal.

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

   This page lists many settings. The most important ones are typically these:

   • Cached Query - Save Source — This 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.

   • Default SQL Schema Name — This specifies the default schema name to use when creating tables from external data. This schema name is used for any tables that do not have a specified schema.

   • Support Delimited Identifiers — This controls how InterSystems SQL treats characters contained within a pair of double quotes.

     If you enable support for delimited identifiers, 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.

3. If you make any change, select Save.

Copy link to this sectionUse 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.

Copy link to this sectionConfiguring 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.Miscellaneous includes methods to set system-wide default and settings.

• %SYSTEM.Process includes methods to set environment values for the life of the current process.

• %SYSTEM.SQL includes methods for changing SQL settings.

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

Copy link to this sectionFor More Information

For more information on the topics covered in this chapter, 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.