This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRISOpens in a new window, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions pageOpens in a new window (login required).

%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 (Including Private)

Methods (Including Private)

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.

Inherited Members

Inherited Methods (Including Private)

FeedbackOpens in a new window