Home / Transact-SQL (TSQL) Migration Guide / Using the TSQL Shell

Transact-SQL (TSQL) Migration Guide
Using the TSQL Shell
Previous section          
InterSystems: The power behind what matters   

The TSQL Shell is one way to execute Transact-SQL code from InterSystems IRIS Data Platform™ .
To use the TSQL Shell, invoke the TSQLShell() method from the Terminal as follows: DO $SYSTEM.SQL.TSQLShell(). This invokes the InterSystems SQL Shell and sets its DIALECT configuration parameter to MSSQL.
You can perform the same operation by invoking the SQL Shell from the Terminal as follows: DO $SYSTEM.SQL.Shell(), then setting the DIALECT configuration parameter. The SQL Shell supports three SET DIALECT options: MSSQL, Sybase, and IRIS.
When in multiline mode, the GO command is used to execute a multiline TSQL statement and exit multiline mode. This statement delimiter is configurable to the statement delimiter defined in imported TSQL code.
For further details about this shell, refer to the Using the SQL Shell Interface chapter of Using InterSystems SQL.
Other Ways to Execute Transact-SQL Code
You can also execute Transact-SQL code:

Previous section          
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-04-23 13:43:22