Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.Opens in a new window

For information on migrating to InterSystems IRISOpens in a new window, see the InterSystems IRIS Migration Guide and Migrating to InterSystems IRIS, both available on the WRC Distributions pageOpens in a new window (login required).


Enable/disable interpreting double-quoted strings as delimited identifiers.


[SQL]    DelimitedIds=n


The value n may be 1 or 0:

  • When 1 (true) a double-quoted string ("My String") is considered a delimited identifier within an SQL statement.

  • When 0 (false) a double-quoted string ("My String") is considered a string constant or literal string.



Range of Values

0 or 1. The default is 1.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, for the Support Delimited Identifiers setting, choose Yes (true) or No (false).

FeedbackOpens in a new window