About This Book
This book describes how to migrate schemas and stored procedures from Sybase or SQL Server and it will provide you with an understanding of the TSQL (Transact-SQL) implementation in InterSystems IRIS® data platform.
The book addresses a number of topics:
An Overview, which includes configuring TSQL, migrating source code and data, and dynamic execution of TSQL code.
InterSystems TSQL Constructs including temporary tables, stored procedures, and transaction management.
InterSystems TSQL Language Elements: data types, operators, literals, reserved words.
For a detailed outline, see the Table of Contents.
When using InterSystems TSQL, you may find the following additional sources useful:
The InterSystems SQL Reference provides details on individual SQL commands and functions, as well as information on the InterSystems SQL configuration settings, error codes, data types, and reserved words.
Using the InterSystems SQL Gateway describes how to use the InterSystems SQL Gateway, which enables you to treat external tables as if they were native InterSystems IRIS® tables.
Using the InterSystems ODBC Driver describes how to use InterSystems ODBC, which enables you to access InterSystems IRIS® tables via ODBC from external applications.
Using Java with the InterSystems JDBC Driver describes how to use the InterSystems JDBC driver, which enables you to access InterSystems IRIS® tables via JDBC from external applications.