Using SQL

Community

Master InterSystems SQL for data management.

Authorsorodriguezz
Version1.0.0
Installs0

System Documentation

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.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: Using SQL
Download link: https://github.com/sorodriguezz/skills-objectscript/archive/main.zip#using-sql

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.