About This Book

This book provides reference material for various elements of Caché SQL: DDL and DML commands, functions, and predicate conditions, and a list of the symbols, data types, and reserved words used in Caché SQL.

This book contains the following sections:

• Symbols

• SQL Commands

• SQL Predicate Conditions

• SQL Aggregate Functions

• SQL Functions

• SQL MultiValue Support Functions

• SQL Unary Operators

• SQL Reference Material

There is also a detailed Table of Contents.

Other related topics in the Caché documentation set are:

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

• Caché 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 Caché with JDBC describes how to access Caché tables from external applications via JDBC.

• Using Caché with ODBC describes how to access Caché tables from external applications via ODBC.

• Caché Advanced Configuration Settings Reference describes the SQL configuration settings.

• Caché Error Reference lists the SQLCODE error messages.

For general information, see Using InterSystems Documentation.