If you're migrating from Oracle to InterSystems IRIS—like many of my customers—you may run into Oracle-specific SQL patterns that need translation.

Take this example:

SELECT (TO_DATE('2023-05-12','YYYY-MM-DD') - LEVEL + 1) AS gap_date
FROM dual
CONNECT BY LEVEL <= (TO_DATE('2023-05-12','YYYY-MM-DD') - TO_DATE('2023-05-02','YYYY-MM-DD') + 1);

In Oracle:

Hi, Community!

Great news for HealthShare® customers! You can use single sign-on (SSO) to access your HealthShare apps more efficiently.

🔒Configuring Federated SSO in HealthShare (video, 11m)

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Succeeding with AI @ Global Summit 2024

https://www.youtube.com/embed/RoKxtWtyu1g
[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]

InterSystems FAQ rubric

The maximum number of namespaces that can be created in one instance is 2047. However, to use a large number of namespaces, you will need to configure memory accordingly.

Works?

When using VS Code client-side editing in combination with a file-based revision control system such as git, I find activities such as branch switching and moving/renaming classes and packages a bit tedious, since you to maintain the connected namespace in sync manually.

Hi Community,

Just to make sure you're up-to-date with the latest happenings on Open Exchange as there have been some updates that you might have missed, but could be really helpful for you. Take a look and see if any of them can benefit you in your work!

Hi Community,

I have created persistent classes for source, target XSDs and completed DTL. When I tested in DTL window by passing source xml it is generating below target xml as result.

DTL result:

Hi Community,

We're pleased to welcome @Wenyi Liu as our new Chinese Moderator in the Developer Community Team!

Let's greet Wenyi Liu with big applause and take a closer look at his bio!

Hello there friends,

I am new to DC and I need to advance up my self.

I see that we get awarded with badges and so on through that process.

But i do not exactly get the idea of it.

I see that we have a challenge of becoming the insightful commenter and so on.

I would like some one to help me out with it so that i could get to the next level.

Regards.

Could someone explain how and why a HL7 ACK be showing up as a Orphaned message when I run the following SQL...

Hey Community,

Great news for all those of you who have missed the Super Early Bird discount for the InterSystems READY 2025! You still have a chance to get an Early bird discount up until 26th of May! So don't miss you chance to participate in the event of the year.

➡️ InterSystems Ready 2025

🗓 Dates: June 22-25, 2025

📍 Location: Signia Hilton Bonnet Creek, Orlando, FL, USA

Hi Community,

We're excited to invite you to the webinar Configuring a Web Server for use with InterSystems IRIS.

Join this webinar for an engaging and insightful tech talk on the configuration of a web server to use with InterSystems IRIS.

⏱ Date & Time: Thursday, February 27, 10:30 AM GMT

👨‍🏫 Speaker: @Steve Mallam, HealthShare Team Lead, InterSystems UK&I