Table Partitioning Demo

This demo walks you through the new Table Partitioning feature in IRIS SQL, explaining what it does and how it works along the way. We'll only use a few dozen rows to prove the concept, but obviously the capability is focused on datasets many orders of magnitude larger.

If you'd like a shorter, higher-level introduction to Table Partitioning, check out the online learning module Managing Tables with Partitioning in InterSystems IRIS

ℹ️ Table Partitioning is included in IRIS 2026.1 as an experimental feature.

What is Table Partitioning?

I have a daily service that consumes x number of files, each file name chronologically suffixed sequentially by _1, _2, etc. I only want to process the latest file.

How do I build a business rule so it will only process the last file?

I created a persistent class with all the associated classmethods that will be needed. I am going to use it as a temp storage for data.

In last post I talked about iris-copilot, an apparent vision that in near future any human language is a programming language for any machines, systems or products. Its agent runners were actually using such so-called 3rd generation of agents. I want to keep/share a detailed note on what it is, for my own convenience as well. It was mentioned a lot times in recent conversations that I was in, so probably worth a note.

Hey Community!

We're happy to share the next video in the "Code to Care" series on our InterSystems Developers YouTube:

⏯ MCP Explained: Bridging the Gap between AI Agents and Tools

Since our previous announcement, we have introduced several incremental improvements to the client‑side editing experience in VS Code. These updates focus on preserving developer‑authored formatting when synchronizing with the server.

What Changed

Client‑side *.cls files previously lost certain formatting details during compilation, including keyword casing (e.g., classmethod → ClassMethod), normalization of blank lines between class members, and removal of line breaks within parameter lists.

#North American Demo Showcase entry. 

>> Answer the question below to be entered in the raffle!

⏯️ AI-Assisted Rare and Complex Disease Detection

This demo shows how InterSystems Health Gateway can be used to pull in outside patient records from networks like Carequality, CommonWell, and eHealth Exchange, creating a more complete longitudinal view in a clinical viewer. That full record is then analyzed by AI to surface potential rare disease considerations with clear reasoning, helping clinicians see patterns they might otherwise miss.

Presenters: 
🗣 @Jesse Reffsin, Senior Sales Engineer at InterSystems
🗣 @Georgia Gans, Sales Engineer at InterSystems
🗣 @Annie Tong, Sales Engineer at InterSystems

Hey Community,

We’re launching a new initiative in which ideas from the Ideas Portal become real applications on Open Exchange, and their authors are rewarded through Global Masters:

💡 Community Bounty Program “Idea to Application” ⚙️

I am connecting to an intersystems cache database via C# and I need to obtain a list of all available namespaces.

I am using code like this:

// Source - https://stackoverflow.com/q/79393836
// Posted by Tony Valenti, modified by community. See post 'Timeline' for change history
// Retrieved 2026-04-21, License - CC BY-SA 4.0
namespace ConsoleApp13
{
   internal class Program
   {
       static void Main(string[] args)
       {
           var CS = "Server=XXXXX;User=system;Password=sys;";
           
           var C = new InterSystems.Data.CacheClient.

The George James Software team is looking forward to going to National Harbor for READY 2026!

As part of the conference, we'll be hosting our Deltanji Source Control User Group:

Date: Wednesday, April 29th 
Time: 8 - 9am (breakfast will be provided) 
Location: Azalea 1 
RSVP by emailing laurelj@georgejames.com. 

We'll be showing what will be included in the next release of Deltanji, version 8.2, as well as providing an opportunity for questions and discussion. We welcome both current and prospective users to join us.

Hi Community,

Can't make it to the National Harbor in person? You can still be part of READY 2026 — two streams will be going live during the event.

The Management Portal doesn't have a native way to switch to Dark Mode. This can be resolved using a Chrome extension called Dark Reader. See the result:

To install and use the Dark Reader:

I'm starting to play more with AI enabled coding. 
I've been using Github Copilot inside Visual studio code, which is very good at coming up with autocomplete suggestions that are accurate and useful. (Along with some utter rubbish, naturally).
For web development I'm starting to use Claude Code in VS Code to help create web sites and integrations. I want to see how it can help with IRIS development. 

However I can't get claude to read any iris code directly as I'm connected to my server via isfs server connections.

Most IRIS developers use $LISTBUILD every day — often without even noticing it.

It is not just a convenient function for building lists. It is also the default internal format used to store row data, global values, and many intermediate structures inside the database engine.

Despite this, the actual binary representation of $LISTBUILD values is rarely discussed. Most developers rely on its behavior, but never look at how the data is really stored.

This article focuses strictly on the binary layout of $LISTBUILD values, based on direct inspection via zzdump.

I need a %SYS.Python object that will be accessible from different processes. The goal is to avoid reinitializing the Python object whenever it is called. Ways that I checked and decided that it is NOT what I want:

• %-variables (process variables). Reusing only in the same process
• Save-and-restore via globals. Restoring means heavy initialization, which I want to avoid

Next, my ideas (none of them look like a silver bullet):

• Using Interoperability Production.

Hello, community.

I've been working with Intersystem Caché for two years, and right away I was excited about the rich ecosystem that Caché provides. However, I was disappointed with calls using #call, and I understand that it was a limitation of the time. Well, the frustration is that #call returns null by default, meaning an AJAX request is executed, but there's no hook to retrieve the return from that request. The only way to retrieve the data from that request is by building a callback on the server side using &js<>.

Hi Guys,

I've this Business operation pointing to my DSN as below 

where its calling the this method, but for some reason its not recognizing Ens.Util.LookupTable class   

What is a Microservice?

A microservice is an architectural style that structures an application as a collection of small, autonomous services. Each component is developed around a specific business capability, can be deployed independently, and is typically managed by a miniature, specialized, self-governing team. (Source: https://microservices.io/)

During my work with customers and also following I often met the 
explicit or embedded question: What is this "GLOBALS" ?
I'll try to explain the history to unfold the context.

Has anyone done this successfully?  Customer wants to receive HL7 data over https using OAUTH 2.0 client credentials.  I am assuming a custom Operation will be needed?  I tried using CoPilot for assistance but was unsuccessful.  I am not great with Object script :( 

Hi Team,

We are currently running InterSystems Caché 2018 on an IBM AIX server and would like to configure the Cache instance to start automatically when the server boots or is rebooted.

Could you please provide the recommended steps or any official scripts/guidelines to enable auto-start for the Cache instance (QA2018) on AIX?

Additionally, if there are any best practices or prerequisites (such as filesystem mount options, service dependencies, or startup order) that we should consider, please share those as well.

Thanks,
Ganesh

The 2026.1 release of InterSystems IRIS® data platform, InterSystems IRIS^® for Health^TM, and HealthShare^® Health Connect is now Generally Available (GA). This is an Extended Maintenance (EM) release.