I have a business service which is responsible for some batch operations with an SQL table. The process is generally slow but it is possible to scale the performance using multithreading and/or parallel processing and logical partitioning (postgres):

Host Variables are a rather common programming feature in many implementations of SQL.
A recent question in DC made me aware that in IRIS, Caché, Ensemble, ...
host variables just exist within embedded SQL

> You can supply host variables for Embedded SQL queries only. <

Related examples are included in the available Documentation

This is a description for a workaround if you don't / can't use embedded SQL.

Dear Community,

As the 🎄 Festive Season 🎄 approaches, we’d like to share our warmest wishes with you. May your holidays be filled with the joy of 🧑‍💻 learning, 🫂 connecting with fellow members, and the excitement of new projects and challenges in the year ahead!

Looking back on 2024, we’re thrilled to celebrate some truly remarkable achievements with YOU, our amazing members:

Our TEST environment and PROD environment are on two different versions of HealthShare Health Connect.

Hi all,

I'm wondering if it is possible to call a Business Operation from other Business Operation.

I have a BO that writes logs into a database, using a personal message. I can create a set obj=##class(MyLogs).%New() but the BO has all parameters about connection.

Is it possible?

Best regards.

Hi there, I'm wondering if anyone has run into an issue with <FILEFULL> when building an image from the ISC image? Specifically what's happening in our build is we are pre-loading our codebase into the image to make deployments faster and setting up source control, etc. When loading our libraries however we get hit with a <FILEFULL>. The resource limits on docker are pretty beefy and when observing resources on both the machine and container level we don't hit any issues. Oddly, this only happens when using the ARM64 version.

I'm running into an intermittent issue with some of our Custom Operations/Processes as a result of some large FHIR R4 Binaries. Essentially we get a response from an AthenaHealth FHIR endpoint that appears to be too large to be processed using the IRIS Built In Functions for FHIR:

I've replicated it on the command line here using a file (binary.json) that has the response from the FHIR Endpoint. Not sharing full contents due to PHI concerns.

We have a business process that seems have extra jobs hanging around. This is what we see in the Jobs tab:

Only the bottom one is actually associated with a process. So what are those other ones? There are no queues and I have no way of finding out why they're there.

Thanks.

What resources have you used to learn InterSystems technologies?

...and how can we improve your experience? Help shape our learning resources by taking a brief survey.

HealthShare Unified Care Record Fundamentals - Virtual December 11-15, 2023 9:00am-5:00pm US-Eastern Time (EST)<

Episode 18 of Data Points features a discussion with Regilo Souza, Patrick Jamieson, and Evgeny Shvarov about the new InterSystems IRIS® FHIR Accelerator Service. This new product offers a turnkey solution for FHIR application developers, and there is an upcoming developer community programming contest around it!

https://5e18edf067eb59-03854285.castos.com/player/437307
[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]

I am seeking work with InterSystems HealthConnect. My experience is working with Rules and DTLs, plus message search, and export of components.

I have actively developed and supported HL7 V2.x interfaces.

I reside in Massachusetts. Open to full-time or contract roles, either local or remote.

I'm sure most of you are familiar with utility %SYS.MONLBL that is crucial when analysing code performance bottlenecks. It allows you to select a number of routines that you want to monitor at runtime and also specify what process(es) you want to watch. BUT, what if you do not know exactly, what process would execute your code? This is true with many web based (CSP/REST) applications today. You want to minimize the resource utilization on your production system that needs analysis. So, how about doing a small tweak?

1. Define an INC file with these macros:

Hi Folks!

Have a very simple question, I hope :)

How can I make sure that user 'John' is already created in the IRIS system?

Preferabbly via SQL?

thanks a lot!