Skip to main content
Previous section   Next section

DelimitedIds

Enable interpreting double-quoted strings as delimited identifiers.

Synopsis

[SQL]    DelimitedIds=n

n is either 1 or 0. The default value is 1.

Description

When DelimitedIds is enabled (n = 1), a double-quoted string ("My String") is considered a delimited identifier within an SQL statement. When this parameter is not enabled, a double-quoted string ("My String") is considered a string constant or literal string.

For further details, refer to the SET OPTION command. For further details on delimited identifiers, see the “Identifiers” chapter in Using InterSystems SQL.

Changing This Parameter

To set the desired value for DelimitedIds from the Terminal, use the SetDelimitedIdentifiers() method of the %SYSTEM.SQL class. See the class reference for details.

You can also change DelimitedIds with the Config.SQL class (as described in the class reference) or by editing the CPF in a text editor (as described in the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).