Seeking Help: Session-Level Configuration for Delimited Identifiers
Hi everyone
I hope this message finds you well. I am currently working with a database system that allows the configuration of certain options using the SET OPTION statement.
SET OPTION SUPPORT_DELIMITED_IDENTIFIERS = TRUE;
I understand that this setting takes effect at the system level, impacting all sessions and processes. However, I am looking for a way to enable support for delimited identifiers that only affects the current session, without altering the global configuration.
My question is:
Is there a way to set options like SUPPORT_DELIMITED_IDENTIFIERS specifically for a single session? If so, how can I achieve this?
Any insights or examples would be greatly appreciated! Thank you in advance for your help!
Best regards,
Comments
No. SUPPORT_DELIMITED_IDENTIFIERS can only be set system-wide, not for just the current session. The documentation states that this option “allows you to change support for delimited identifiers system-wide” and that “once set, this option takes effect system-wide for all processes.” [1]
You can change it with either:
SET OPTION SUPPORT_DELIMITED_IDENTIFIERS = TRUE|FALSE$SYSTEM.SQL.Util.SetOption()using theDelimitedIdentifiersoption [1][2][3]
You can check the current setting with:
By contrast, the same SET OPTION page explicitly says that locale options apply “for the current process,” which highlights that SUPPORT_DELIMITED_IDENTIFIERS is not a session/process-level option. [1]
Note:
Delimited identifiers are required by other features of InterSystems IRIS, such as InterSystems IRIS Business Intelligence. As such, take care when disabling them to ensure that other parts of your configuration are not affected. [2]
Sources: