Hi, I am unsure how to remove this restriction; when I am performing dynamic SQL using ##class(%SQL.Statement).%ExecDirectNoPriv(, .query, args...)

It works fine, but the moment I add specific properties from the persistent class I am performing the select on into the WHERE clause, I get: ERROR #5540: SQLCODE: -99 Message: User UnknownUser is not privileged for the operation. Despite using %ExecDirectNoPriv, I've tried with prepared statement as well, exact same situation.

Hi, Community!

What new products or technologies do you want to try in 2025? Set your 2025 goals with these top learning resources.

So I know we can run routines using both XECUTE or @
However both of them run slower than just running the routine without it. (that is because as far as i understand, XECUTE command for example will re-compile before running?)

the question is: how can I run a routine by name - and keeping the performance as good as possible?

I have been trying to track down an issue we are seeing in our TEST environment with Memory usage.

We have Several BP's for years now that take a HL7 message, parse it apart, and make calls to a Custom EnsLib.SQL.OutboundAdapter to have it execute Insert/Select/Update/Delete stored procedures against a MS SQL Database via JDBC connection. We are using Microsoft's JDBC 12.2 driver to do this.

What we are seeing is that IRIS.WorkQueue globals are being defined for these calls but then the IRIS.WorkQueue is not being cleaned up and taking up large amounts of Memory.

Hey Community,

We're excited to introduce a new series of videos dedicated to Gen AI on our InterSystems Developers YouTube:

⏯ 3 GenAI Model Training Opportunities

https://www.youtube.com/embed/L24FZfvryd8
[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 Community,

Play the new video on InterSystems Developers YouTube:

⏯ FHIR to IntegratedML - Can You Get There From Here @ Global Summit 2023

https://www.youtube.com/embed/L5sl1tbyJGY
[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 Everyone,
Do you know that April 22 was the Earth Day?
Join us in celebrating Earth Day on Global Masters - by learning about our efforts for sustainability and how you can drive change on a personal level.
There you will not only learn about ways to reduce your carbon footprint, but you will also have the opportunity to get some extra points for it. The campaign is live till April 30✨
It's also a good time to check the reward catalog - we added a couple of new prizes for several regions. Hope you will enjoy them!

Hello,

Our software commonly returns a full result set to the client and we use the DataTables plugin to display table data. This has worked well, but at datasets grow larger, we are trying to move some of these requests server-side so the server handles the bulk of the work rather than the client. This has had me scratching my head in so many ways.

I'm hoping I can get a mix of general best practice advice but also maybe some IRIS specific ideas.

Some background

Hi All,

After doing IRIS/Ensemble etc for 20 years I've come across a company who have very odd view, especially about DTL's and routers.

They have convinced themselves to use COS for transforms (including HL7) and for routers (and one of their 3rd party providers agree!)

Their reasons are; efficiency, compatibility, flexibility, power and re-usability.

Of course these reasons are wrong!

Using Flask, REST API, and IAM with InterSystems IRIS

Part 1 - REST API

Hello

In this article we will see the implementation of a REST API to perform the maintenance of a CRUD, using Flask and IAM.

In this first part of the article we will see the construction and publication of the REST API in Iris.

First, let's create our persistent class to store the data. To do this, we go to Iris and create our class:

In HealthShare, we can add any new application that will show up in the left menu of the viewer. I am trying to add new navigation entries that will look like 'patient search' popup.

- Is Intersystems sharing its HealthShare style? They are using material tags, but it looks very different that the default material themes. I probably can pick up the style, but perhaps there is an official way.
- Is there a way to do a popup like patient search? So far I see, a new option is associated to an url not some javascript code?

Thank you for your help.

Please let your clients and others on your ISC team know that currently there are spots available for the following June courses which currently have a low registration:

Hello everyone,

How can i download the iris odbc for linux ubuntu in order to recover the file 'libirisodbcu.so'.

thanks in advance