Skip to main content

This documentation is for an older version of this product. See the latest version of this content.Opens in a new tab

Sorry, your browser does not support JavaScript or JavaScript is disabled. Please enable JavaScript or use another browser to have a better experience.

PAGE_release_sc

SCINTRO
PAGE_deployment_sc

PAGE_administration

PAGE_platform_arch_design

PAGE_security

PAGE_interoperability_sc

PAGE_data_science

PAGE_embedded_language_development

PAGE_multimodel
GORIENT
PAGE_objectscript

Embedded Python

GGBL
Class Programming

PAGE_apimgr
Current Page: PAGE_sql

GSQL
GSQLSRCH
PAGE_security_sql
Optimizing SQL

RSQL
BSQG

GDOCDB
PAGE_webapps

Other Available APIs

Other Topics

RGOT

Developer Tools

PAGE_external_language_development

Class Reference

Download all PDFs

SQL

InterSystems Supply Chain Orchestrator™ provides high-performance, full-featured SQL access. You can use SQL with Supply Chain Orchestrator at scales from queries running on a single CPU core, to parallel queries using dozens of cores, to distributed queries across a cluster of Supply Chain Orchestrator servers.

InterSystems SQL is fully integrated with Supply Chain Orchestrator object technology and also provides connectivity with ODBC and JDBC clients. Other features include automatic parallel query execution, transparently distributed queries, and support for both standard SQL queries and stored procedures.

Get Started

Try a hands-on exerciseOpens in a new tab on running fast SQL queries in InterSystems IRIS.
InterSystems SQL OverviewOpens in a new tab is an online course that gives a hands-on introduction to class queries, dynamic SQL, and embedded SQL.

Categories

Using InterSystems SQL provides information about using SQL with InterSystems databases.
InterSystems SQL Performance Optimization explores performance optimization tools.
InterSystems SQL Reference offers detailed reference information on InterSystems SQL commands, functions, operators, and more.
SQL Gateway Overview describes how to enable Supply Chain Orchestrator to access external databases via both JDBC and ODBC.

Related Content

SQL Search provides an overview of the InterSystems IRIS Natural Language Processor (NLP), which allows you to perform context-aware text search operations on unstructured data.
Developing with InterSystems Objects and SQLOpens in a new tab describes the offering from InterSystems Classroom Training for InterSystems SQL.