#InterSystems IRIS

I did some experiments on my local machine and found out that IRIS seems to associate each request (eg: CSP request) to a dedicated process named IrisDB.exe

This process has 3 threads, and one of them seems to be the main working thread (that will the handle request).

If I spawn many concurrent requests, the number of IrisDB processes on my local machine will grow (to make sure each request can be handled in parallel).

It seems there is a limit : it will create no more than 64 processes to handle requests (eg: even if 100 concurrent requests are send to IRIS).

Hello everyone,

I am working with InterSystems IRIS and seeking guidance on how to perform specific tasks related to the FHIR SQL Builder using commands or code, rather than the graphical user interface (GUI). The specific tasks I am trying to accomplish are:

I need to convert a JSON payload to a custom object type. Currently, I'm converting the JSON object to a %Library.DynamicObject object and need to proceed from here.

As of now, these are my options

1. Using an external library talked about in this link:

Is it possible execute create table from management portal?

I tried this:

CREATE TABLE SQLUser.Teste(ID INT NOT NULL, coluna1 VARCHAR(255), coluna2 VARCHAR(255), coluna3 VARCHAR(255), coluna4 VARCHAR(255)CONSTRAINT TestePK PRIMARY KEY (ID))

Error message:

How use column (auto_increment)?

Is it possible train an IntegratedML model on docker build or docker up?

Hello,

Could someone help me with a solution, for example "dump" to IRIS.DAT, I mention that it is difficult to manipulate a file of ~ 200 GB. I would be interested in generating an IRIS.DAT file containing the "schema" without any information.

Thanks !

I am getting this "Studio Item 'Ens.StringResponse' is mapped from a database that you do not have write permission on. " if I am pressing any key in that class. I need to define some Property inside it. How Can I do the same

I am trying to use postman to start the restapi classes from a json openapi2.0.0 file.

POST: https://myserver.com/api/mgmnt/v2/requestAPI. The body contains the openapi2.0.0. The application api/mgmnt has in security settings: password. JWT is not selected. I set postman authentication to basis authentication and gave username and password. I also set in headers IRISUsername and IRISPassword. I have 401 Unauthorized.

Is the only way to go through is to build an oauth token? or do I miss something?

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:

How Can I do to receive and read an uploaded file from a HTML form or REST API formdata into a Custom EnsLib.HTTP.InboundAdapter?

Is it possible see the execution plan of a SQL sentence in IRIS?

Like this:

explain plan for
select  e.ename,r.rname
from    employees  e
join    roles       r on (r.id = e.role_id)
join    departments d on (d.id = e.dept_id)
where   e.staffno <= 10
and     d.dname in ('Department Name 1','Department Name 2');

That returns this:

I'm trying to send a message into a production on change a persistent object.

And when I change an object using SQL - I get an error,
when change the object using objectscript - I get a message (but not an error or exception)
But the most interesting - everything works fine (the object has been changed, and business service receives data)

Persistent class

During a discussion of implementing a private ZPM Registry
I met the question of how to unpublish (or lock) a published package.

Digging articles and docu up and down I was unable to find an answer.
Any hint on where to search is welcome.

NB. local install / uninstall is clear.