#InterSystems IRIS

I've writing a short classmethod that extracts an HL7 message from EnsLib.HL7.Message by ID and returns it as a stream. It's to be called as a stored procedure via ODBC (or ADO.NET) to fetch messages into an application.

I'm not using an SQL query in the classmethod itself, but it will be called as part of an SQL query via ODBC, but I can't figure out how to set a custom SQLCODE and error text from within the classmethod that propagates back to the external application. I thought %sqlcontext would be useful for this, but it doesn't appear to do anything. Here's the class:

A lot of developers like to work with Studio and have been looking into source code version control such as GIT or into enabling modern development workflows like CICD or DevOps processes.

This article describe an elementary solution to get you started in CICD and DevOps, even if you are not yet ready to move to Atelier or forth coming VS Code approach which enable client side source code version control.

Some clients ask me about migrate from Cache to IRIS. Why migrate to IRIS? Cache is excellent, stable, has good performance. These clients are right, but in the last years, the digital transformation imposed more complete solutions for the new requirements and InterSystems was a visionary to perceive it and launch IRIS.
It is a data platform ready to this digital transformation challenge. To show this, I created a Value Canvas.

Hi Developers!

Please welcome the new video on InterSystems Developers YouTube:

⏯ Data Platform Scalability

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

Hi,

InterSystems IRIS has long supported the obvious translation functions required to for converting to upper or lowercase to enforce case-insensitive string comparison (e.g. in ObjectScript with $zconvert) and sorting (e.g. with SQL collation functions, not to be confused with NLS collation). Customers in international contexts have at times used custom workarounds to also treat accent insensitivity or even more advanced normalization duct tape. We’re looking to address such use cases at the system and SQL level to increase convenience for this international audience, which is well represented on the Developer Community.

There are many options to do a full security scan in your docker images, the most popular option is Anchore community edition.

Anchore will use the main public vulnerabilities databases available, including CVE.

To install Anchore is very ease (source: https://engine.anchore.io/docs/quickstart/), follow the steps:

Hey Community,

We want to hear from you! Give us your feedback on the past InterSystems Analytics programming contest! Please answer some questions to help us improve our contests.

👉 Quick survey: InterSystems Analytics Programming Contest Survey

Hello all,

First time post and newer to Cache/ObjectScript in general, please keep it in mind!

II try to explore the new SQL LOAD DATA feature in SQL comparing it to SQL INSERT

I'm stuck at this point: INSERT INTO <table> (columns...) VALUES (.....)
allows having not just simple column references but also ALL Standard SQL FUNCTIONS (at least)
example:

INSERT INTO Test (ShortName,DOB) VALUES (SUBSTRING(Name,1,4),TO_DATE(displayDate,'MM-DD_YYY'))

This works perfectly.
BUT the same VALUE clause applied to LOAD DATA fails in various ways:

Hey Community,

Don't miss the latest videos on InterSystems Developers YouTube channel:

⏯ IntegratedML Update from the Field

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

Hi

I'm using an embedded SQL statement with a a cursor-based Embedded SQL query that uses host variables in the where clause, however, what I'm doing doesn't seem to work. Can anyone help?

The code I'm using is

Hi Community,

We are glad to invite you to the upcoming Interoperability Contest Kick-off Webinar: Building Sustainable Solutions! The topic of this webinar is dedicated to the Interoperability programming contest.

In this webinar, we'll show you some of the general principles and problems of solving sustainability challenges, as well as some great ideas that came up in hackathons for inspiration and do's and don'ts.

Also, we’ll discuss and answer the questions on how to build interoperability solutions using InterSystems IRIS and IRIS for Health.

Date & Time: Monday, August 29 – 09:00 AM EDT

Speakers:
🗣 Tomas Studenik, CEO of Insane Business Ideas and co-founder of Caelestinus
🗣 @Dean Andrews, Head of Developer Relations
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

Hi Friends,

In my production already we have business components (business service , process, operations) and all are working fine.

Now I have change the package structure of few classes and want to update the references in settings for Business components in Management portal.

As this class field is read only , Any other way to update the class reference, instead of creating new business component?

Hello guys,

i try to call a Operation within 3 foreach loops.

When i try to do this, i always get the following error:

I dont get any Errpr when i log my request message at this time i want to call a operation.

Everything works and i get no error. But when i try to call the operation i get this error.

Then i tried to call a operation in the first Level (not in a ForeachLoop) it works.