About This Book

This book provides reference material for various elements of InterSystems SQL on InterSystems IRIS® data platform: DDL and DML commands, functions, and predicate conditions, and a list of the symbols, data types, and reserved words.

This book contains the following sections:

• Symbols

• SQL Commands

• SQL Predicate Conditions

• SQL Aggregate Functions

• SQL Functions

• SQL Unary Operators

• SQL Reference Material

There is also a detailed Table of Contents.

Other related topics in the documentation set are:

• Using InterSystems SQL provides in-depth material on SQL components and features, executing SQL queries, error and transaction processing.

• SQL Optimization Guide describes how to optimize a table definition by defining and building indices, how to use Tune Table to optimize table metadata based on typical data, and how to optimize query execution using cached queries, ShowPlan, frozen plans, and other optimization techniques.

• Using Java with the InterSystems JDBC Driver describes how to access InterSystems IRIS® tables from external applications via JDBC.

• Using the InterSystems ODBC Driver describes how to access InterSystems IRIS® tables from external applications via ODBC.

• System Administration Guide lists the Management Portal SQL and Object Settings Pages.

• InterSystems Error Reference lists the SQLCODE error messages.