I need to reproduce a table (in fact a view, but let's start with a simple table 😊) in IRIS as the currently used in Oracle.

I need to expose/project one column to JDBC as CLOB, in my class I have the corresponding property defined as:

Property GlobStream As %Stream.GlobalCharacter;

In JDBC this column is projected as LONGVARCHAR, this is compliant with the documentation but I need to project it as CLOB.

In addition, I'm no expert in JDBC but wit seems that LONGVARCHAR has a Maximum Length 32,700 characters in JDBC, not quite enough for an arbitrary stream.

0 3
0 21
InterSystems Developer Community is a community of 26,089 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

This is an excellent candidate for a developer community post (like Dev.to, Medium, or the InterSystems Community). It bridges the gap between high-level architecture and hands-on implementation.

Here is the summarized article format.

Open Exchange app
1 0
0 9

Project Overview:

The Clinical Staff Master Data Management (CSMDM) system is a full-stack healthcare integration application built on InterSystems IRIS for Health. It centralizes and standardizes clinical staff metadata into a single authoritative repository, exposed through RESTful CRUD APIs and reusable backend methods.

The platform eliminates fragmented lookup tables and hardcoded mappings that commonly cause errors in HL7 and FHIR integration workflows, ensuring data consistency and interface reliability.

Open Exchange app
1 0
0 5

Hi everyone,

This is the first time I'm dealing with a request of modifying a variable value in a UDF OnSQLTrigger on InterSystems TrakCare.

I can't find any documentation to address this issue, but basically, my goal is to modify the value of one of the fields in a table when it is first inserted.

This is basically what the code should do, namely, to change the content of the %d variable at a specific key.

0 10
0 81
Question
· Aug 31, 2025
Cache Studio for IRIS 2024.3

Greetings,

As a long time Cache developer is there a way to get a copy of the Cache Studio that supports IRIS 2024.3? I do not have a WRC account? I need Studio just to experiment, not to build commercial software.

Thank you,

Everardo

1 6
0 192

Hi, Community!

👩‍⚕️If you need to access clinical data at scale, the InterSystems Bulk FHIR Coordinator can help!

Using the InterSystems Bulk FHIR Coordinator to Extract Clinical Data

https://www.youtube.com/embed/DFiHQYhDGMo?utm_source=youtube&utm_medium=social&utm_campaign=DFiHQYhDGMo
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 8

Hello DC community,

InterSystems Certification is currently developing a certification exam for ObjectScript developers, and if you match the exam candidate description below, we would like you to beta test the exam! The exam will be available for beta testing starting February 18th, 2026.

Beta testing will be completed May 4, 2026.

2 1
1 34

Hey Developers,

Watch this video to learn about automating the provisioning and management of FHIR services:

⏯ Automating Provisioning and Management of FHIR Services @ Ready 2025

https://www.youtube.com/embed/QqA92pDISI4
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 13

We are attempting to "Repoint" old class data to new class data to save disk space and data redundancy across multiple tables. This works to a point. In essence the two classes are sharing the same data / Index / stream globals. But if an ID in the Old_Class is opened, a property is modified, and saved the property that is in the New_Class (but not in the Old_Class) is NULLed / blanked.

0 10
0 64

Intersystems IRIS Productions provide a powerful framework for connecting disparate systems across various protocols and message formats in a reliable, observable, and scalable manner. intersystems_pyprod, short for InterSystems Python Productions, is a Python library that enables developers to build these interoperability components entirely in Python.

14 0
3 101

Hi Community,

We're happy to announce that registration for the event of the year — InterSystems Ready 2026 — is now open. This is the premier global summit for the InterSystems technology community – a gathering of industry leaders and developers at the forefront of their respective industries. This event attracts a wide range of attendees, from C-level executives, top subject matter experts and visionary leaders, managers, directors and developers. Attendees gather to network with peers, connect with InterSystems partners, learn best practices and get a firsthand look at upcoming features and future innovations from InterSystems.

➡️ InterSystems Ready 2026

🗓 Dates: April 27 - 30, 2026

📍 Location: Gaylord National Resort & Convention Center, National Harbor, Maryland, USA

3 2
0 33

Hi,

I'm having a problem with %JSON.Adaptor and "list of" binding.

For exemple, this class with a property "oazisCode As list of %String".

Class User.ADGroup Extends (%Persistent, %JSON.Adaptor)

{
/// Code interne
Property code As %String;

/// Libellé
Property text As %String(MAXLEN = "");

Property oazisCode As list Of %String;

}

The first time call to %JSONImport works properly

0 5
0 42
Hello and welcome to the InterSystems Ideas Portal Annual Recap 2025.
General Stats:
✓ 182 new ideas in 2025
✓ 44 new implementations in 2025
✓ 174 new comments in 2025
✓ 725 new votes in 2025
✓ 232 new users in 2025
✓ 713 ideas all time
✓ 132 implemented ideas all time
✓ 991 comments all time
✓ 3,426 votes all time
✓ 1,207 users all time

4 2
1 41

Why do these clauses affect SQL performance?

select ID from some_table where row_status in ('I','U') order by ID limit 5 - makes the query infinite
select top 10 ID from some_table where row_status in ('I','U') order by ID - the same
select ID from some_table where row_status in ('I','U') order by ID - is fast

Actually there are no rows in the table having row_status 'I' or 'U'.

I asked Gemini and it recommended me rewrite the query as

0 15
0 149

In this article, I aim to demonstrate a couple of methods for easily adding validation to REST APIs on InterSystems IRIS Data Platform. I believe a specification-first approach is an excellent idea for API development. IRIS already has features for generating an implementation stub from a specification and publishing that specification for external developers (use it with iris-web-swagger-ui for the best results). The remaining important thing not yet implemented in the platform is the request validator. Let's fix it!

Open Exchange app
2 0
0 39