docs.intersystems.com
Caché SQL Reference
About This Book
[Home]
[Back]
[Next]
Caché Development References
>
Caché SQL Reference
>
About This Book
Search
:
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
.
Send us comments on this page
Copyright
© 1997-2019 InterSystems Corporation, Cambridge, MA
