Using SQL
CommunityMaster 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 requiredComponents
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.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.