docs.intersystems.com
InterSystems IRIS Data Platform 2019.2
/
InterSystems SQL Reference
InterSystems SQL Reference
About This Book
Search
:
This book provides reference material for various elements of InterSystems SQL on the 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.
Advanced Configuration Settings Reference
describes the
SQL configuration settings
.
InterSystems Error Reference
lists the
SQLCODE error messages
.
Send us comments on this page
View this book as PDF
|
Download all PDFs
Content Date/Time: 2019-08-22 05:46:30
