%SYSTEM.TSQL

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-2020 InterSystems Corporation, Cambridge, MA