DelimitedIds

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. Also see SQL Identifiers.

Changing This Parameter

To set the desired value for DelimitedIds from the Terminal, use the SetOption(“DelimitedIdentifiers”)Opens in a new tab method of the %SYSTEM.SQL.UtilOpens in a new tab class. See the class reference for details.

You can also change DelimitedIds with the Config.SQLOpens in a new tab class (as described in the class reference) or by editing the CPF in a text editor (as described in Editing the Active CPF).