docs.intersystems.com
Home  /  Migration Options from Third-Party Databases  /  Transact-SQL (TSQL) Migration Guide  /  Using the TSQL Shell


Transact-SQL (TSQL) Migration Guide
Using the TSQL Shell
[Back] 
InterSystems: The power behind what matters   
Search:  


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: