Skip to main content
Next section

About This Book

This book describes how to use the InterSystems SQL, which provides standard relational access to data stored within a database on InterSystems IRIS® data platform.

The book addresses the following topics:

The InterSystems SQL language:

  • Introduction to InterSystems SQL” provides an overview of InterSystems SQL as it relates to software standards and interoperability.

  • InterSystems SQL Basics” describes the fundamental features of InterSystems SQL (such as tables and queries), especially those that are not covered by the SQL standard or are related to InterSystems IRIS® unified data architecture.

  • Language Elements” describes how InterSystems SQL handles the basic elements common to any programming language: numbers, strings, operators, NULL, and comments.

  • Identifiers” describes the conventions used for naming entities within InterSystems SQL.

Data Definition: creating tables and views:

Data Management: querying and modifying data:

  • Querying the Database” describes how to create and use SELECT queries.

  • Implicit Joins” describes an InterSystems SQL extension that provides arrow syntax for implicit joins. InterSystems SQL also provides standard syntax for explicit joins.

  • Modifying the Database” describes how to use INSERT, UPDATE, and DELETE to modify data, and how to use transactions to group multiple data modifications.

SQL execution interfaces:

  • Using Embedded SQL” describes how to write and execute SQL code embedded within ObjectScript code. This chapter also describes SQL cursors, which enable you to access multiple rows of data.

  • Using Dynamic SQL” describes how ObjectScript can include SQL that is executed at runtime.

  • Using the SQL Shell” describes how to write and execute SQL statements from the Terminal.

  • Using the Management Portal SQL Interface” describes how to write and execute SQL statements from the Management Portal.

  • Importing SQL Code” describes how to execute SQL statements by importing them from a text file. This interface can be used for InterSystems SQL code or SQL code in other vendor formats. Import SQL code can be used to define tables and to populate tables with data; it cannot be used to query data.

SQL interface:

For a detailed outline, see the Table of Contents.

When using InterSystems SQL, you may find the following additional sources useful:

Next section