Class Reference
Cache for UNIX 2018.1.2
InterSystems: The power behind what matters   
Documentation  Search
Private  Storage  

abstract class %SYSTEM.TSQL extends 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()

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
9


Summary

Methods
CurrentSettings GetAnsiNulls GetCaseInsCompare GetDialect
GetQuotedIdentifier Help 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:
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:
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:
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:
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.


Copyright © 1997-2019, InterSystems Corporation