%SYSTEM.TSQL
abstract class %SYSTEM.TSQL extends %SYSTEM.Help
The %SYSTEM.TSQL class provides an interface for managing Caché TSQL configurations.You can use it via the special $SYSTEM object:
Do $SYSTEM.TSQL.SetAnsiNulls("sybase","on")
You can call help to get a list of all entry points:
Do $SYSTEM.TSQL.Help()
Method Inventory
- CurrentSettings()
- GetAnsiNulls()
- GetCaseInsCompare()
- GetDialect()
- GetQuotedIdentifier()
- SetAnsiNulls()
- SetCaseInsCompare()
- SetDialect()
- SetQuotedIdentifier()
Methods
classmethod CurrentSettings()
This method will return the current setting that are defined for InterSystems TSQL compatibility features.
classmethod GetAnsiNulls() as %String
This method returns the current default TSQL dialect and the value for TSQL Ansi Null behavior.
valid values aare ON or OFF
classmethod GetCaseInsCompare() as %String
This method returns the current default TSQL dialect and the value for TSQL non-case-sensitive equality comparison behavior.
valid values aare ON or OFF
classmethod GetDialect() as %String
This method returns the current default TSQL Dialect for the System. The two options are Sybase and MSSQL
classmethod GetQuotedIdentifier() as %String
This method returns the current default TSQL dialect and the value for TSQL Quoted Identifier behavior.
valid values aare ON or OFF
classmethod SetAnsiNulls(Dialect, flag) as %String
This method sets the current default TSQL dialect and the value for TSQL Ansi Null behavior.
Parameters:
Returns: The previous default TSQL dialect value and Ansi Null behavior
Parameters:
- Dialect
- Name of the TSQL dialect: Sybase or MSSQL
- flag
- Value for TSQL Ansi NULL behavior: ON or OFF
Returns: The previous default TSQL dialect value and Ansi Null behavior
classmethod SetCaseInsCompare(Dialect, flag) as %String
This method sets the current default TSQL dialect and the value for TSQL non-case-sensitive equality comparison behavior.
Parameters:
Returns: The previous default TSQL dialect value and TSQL non-case-sensitive equality comparison behavior.
Parameters:
- Dialect
- Name of the TSQL dialect: Sybase or MSSQL
- flag
- Value for TSQL non-case-sensitive equality comparison behavior: ON or OFF
Returns: The previous default TSQL dialect value and TSQL non-case-sensitive equality comparison behavior.
classmethod SetDialect(Dialect) as %String
This method sets the default TSQL Dialect for the System.
Parameter:
Returns: The previous default TSQL Dialect value or an invalid error message
Parameter:
- Dialect
- Name of the TSQL dialect: Sybase or MSSQL. The Default is Caché SQL
Returns: The previous default TSQL Dialect value or an invalid error message
classmethod SetQuotedIdentifier(Dialect, flag) as %String
This method sets the current default TSQL dialect and the value for TSQL Quoted Identifier behavior.
Parameters:
Returns: The previous default TSQL dialect value and TSQL Quoted Identifier behavior.
Parameters:
- Dialect
- Name of the TSQL dialect: Sybase or MSSQL
- flag
- Value for TSQL Quoted Identifier behavior: ON or OFF
Returns: The previous default TSQL dialect value and TSQL Quoted Identifier behavior.