skills.rest
sorodriguezz
sorodriguezzCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

Using SQL

Operate InterSystems SQL within the InterSystems IRIS data platform.

Updated Feb 2, 2026
Search Tags:#database#data management#sql#querying#objectscript#intersystems
One-click install
npx skills add https://github.com/sorodriguezz/skills-objectscript --skill using-sql
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Using SQL
Source: https://github.com/sorodriguezz/skills-objectscript/tree/main/skills/using-sql
Command: npx skills add https://github.com/sorodriguezz/skills-objectscript --skill using-sql

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides comprehensive guidance and operational instructions for utilizing InterSystems SQL, enabling users to effectively manage and query data within the InterSystems IRIS data platform.

Core Features & Use Cases

  • SQL Syntax and Execution: Learn about InterSystems SQL syntax, including embedded and dynamic SQL, and various execution interfaces like the SQL Shell and Management Portal.
  • Data Management: Understand how to define tables, views, manage data (INSERT, UPDATE, DELETE), and utilize stored procedures.
  • Interoperability: Explore JDBC and ODBC drivers for seamless integration with other tools and applications.
  • Use Case: A developer needs to integrate data from an external relational database into their InterSystems IRIS application. They can use the SQL Gateway and the provided information on ODBC/JDBC to achieve this.

Quick Start

Use the Using SQL skill to learn how to embed InterSystems SQL code within ObjectScript.

Frequently Asked Questions about Using SQL

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I use SQL in InterSystems IRIS to manage relational data?▼

You can use InterSystems SQL to manage relational data by defining tables and views, executing INSERT, UPDATE, and DELETE operations, and utilizing stored procedures within the InterSystems IRIS data platform. The Skill provides operational guidance for these core data management tasks.

What is the difference between embedded and dynamic SQL in ObjectScript?▼

InterSystems SQL supports both embedded and dynamic SQL execution within ObjectScript. Embedded SQL is directly integrated into ObjectScript code, while dynamic SQL is parsed and executed at runtime, offering flexibility for varying query structures within the InterSystems IRIS environment.

Can I connect external applications to InterSystems IRIS using JDBC and ODBC?▼

Yes, InterSystems SQL provides JDBC and ODBC drivers for seamless interoperability. You can connect external applications and integrate data from external relational databases into your InterSystems IRIS application using the SQL Gateway and these provided drivers.

How do I execute InterSystems SQL queries through the Management Portal?▼

InterSystems SQL queries can be executed through the SQL Shell and the Management Portal. These execution interfaces allow database administrators and developers to directly run SQL syntax, test queries, and manage data within the InterSystems IRIS data platform.

Does InterSystems SQL support schema definitions and security configurations?▼

Yes, InterSystems SQL supports schema definitions and security configurations. It provides comprehensive operational instructions for defining database schemas, managing relational data structures, and securing your data within the InterSystems IRIS data platform environment.

Related Skills

Explore More Software Engineering Skills→
sorodriguezzsorodriguezz

Using the Callin API

Execute InterSystems IRIS commands and evaluate ObjectScript expressions from C/C++ programs.

Community
Advanced
sorodriguezzsorodriguezz

XDBC Gateway

Connect InterSystems IRIS to external relational databases via JDBC and ODBC.

Community
Intermediate
sorodriguezzsorodriguezz

System Administration Guide

Guide system administrators through InterSystems IRIS Management Portal configuration and monitoring.

Community
Intermediate
sorodriguezzsorodriguezz

Using Document Database (DocDB)

Create, manage, and query JSON documents in InterSystems IRIS DocDB.

Community
Intermediate