Hi Community,

Play the new video on InterSystems Developers YouTube:

⏯ How We Used AI to Build Faster Sell More and Support Better @ Global Summit 2024

Hi all,

We have an restriction in a SQL database with a unique index.

We want to catch that exception when it tries to insert or update a value that violates the unique index condition.

// run the querySet tSC = ..Adapter.ExecuteUpdateParmArray(.nrows,SQL,.param)

// Check if there is any errorIf$$$ISERR(tSC)
{
	Set msgError = $System.Status.GetErrorText(tSC) 
	// Check here if the native error code is 2601 (Cannot insert duplicate key row into object 'MYPATIENTS' with unique index 'UQ_UNIQUE_INDEX')
	??????
}

I've tried to get the ..Adapter.%SQLCODE, but it is empty

Hi All,

I'm trying to connect to an IRIS instance using VSCode, the problem is, there are 2 IRIS instances installed on this server, published by the same hostname using https (port 443) under 2 different subfolders (e.g., iris.demo.com/base & iris.demo.com/test).

When connecting via studio, I was able to connect by using the hostname (e.g., iris.demo.com) and specifying the super server port, while when connecting through VSCode, when specifying the web server port 443, the connection is always defaulted to one of the instance.

Is there any way we can specify the instance in VSCode?

Many thanks!

How can I display the patch version?

The command Write $system.Version.GetPatchId()
doesn't show anything.
What other options are there?
Thanks.

SOURCFILE="/home/user1/file1.dat"

DESTFILE="/opt/users/file1.dat"

##class(%File).Rename(SOURCFILE,DESTFILE,.STATUS) when this is executed in IRIS,  SOURCEFILE is getting moved to the folder in DESTFILE but it is not getting deleted from SOURCEFILE folders. Same call is working as expected in cache. Has anyone experienced this issue? We are trying convert to IRIS from cache.

I have a BPL iterating over Dynamic arrays. Can I add Dynamic Array (%Dynamic Abstract Object) and also %Iterator.Array to BPL context? I tried and I see Error: %AddToSaveSet method does not exist for %Iterator.Array

Is it possible to install IRIS Studio as an evaluation, so I can use the built-in IDE? 

I have installed IRIS Community edition that does not come with a built-id IDE. 

Altelier website is down down.

VSCode with ObjectScript - tried to run simple MUMPS code and says not supported

I am experiencing an issue while executing a stored procedure in InterSystems Cache. Here’s the procedure I createdCREATE PROCEDURE Silk.sp_InsertRecord (    IN RecordDate TIMESTAMP,    IN UserName VARCHAR(50),    IN RecordType INT,    IN RecordID VARCHAR(50),    IN CategoryID INT,    IN ApprovalDate TIMESTAMP,    IN FileSize BIGINT,    IN WorkstationName VARCHAR(50))BEGIN     INSERT INTO DummyRecords (        RecordKey,         FilePath,         RecordDate,         UserName,         RecordType,         RecordID,         CategoryID,         FileSize    )     VALUES (       

I have an IRIS installation that is using 8-bit charset encoding (set to deu8 / Latin 1). I would like to convert everything (database and system)  to Unicode

Charset encoding is something asked during installation, is it possible to change this on the fly ? The installer clearly say that Unicode systems cannot be converted. What about 8 bit ? 

Same for database : is there possible conversion ?

My current plan is the following :

- export all globals from 8-bit instance
- install a new Unicode instance
- import all globals into Unicode instance

Is there a simpler approach ?

Good morning

We are looking for a Senior Database Manager for a contract position with a health agency. It's a two and a half year contract, fully remote.

Please review the opportunity by clicking the link below and if you qualify, please let me know if you are interested in speaking about the opportunity.

More info here: https://teckpert.applytojob.com/apply/okkPyvcJn5/Senior-Database-Manager-Intersystems

Need to be based in the US and have work authorization.

Please apply to the link above.

Best,

Gabriel

We've just made a change to Server Manager with the aim of it coping better when a stored password is no longer valid, for example because it has been changed.

We plan to include this in the next published version (no release date yet set), but if you'd like early access please download the v3.6.3-beta.3 VSIX and install it, for example by dragging it from your file explorer onto the Extensions view in VS Code.

Many programming languages use the try-and-catch construct to handle runtime errors gracefully. If the code within the try block encounters an error, it will throw an exception to the catch block, where the error handling occurs. Today we will dive into the ObjectScript implementation of this construct and discuss some ways to clean things up.

ObjectScript Implementation Basics

To get started, we will first look at the basic structure of the try/catch block:

try{
    //some code here
}
catch ex{
    //some error handling here
}

Can InterSystems IRIS Data Platform 2019  be Integrated with Snowflake?

From InterSystems Do we have any predefined packages or Adapters available to Connect with Snowflake?

Can InterSystems  be Connected with Snowflake through Web Gateway Management?

I added a Response Message Class to a call in the Business Process Designer.

When i click on Response Actions or on Response Builder i get a message

"You must specify a response message class in order to add or edit response actions."

no matter which response message i choose i always get the above warning.

how do i fix this?

Thanks

Is it OK to load files (UDL format in my case) using the $system.OBJ.Load() function from multiple processes ? 

In other words ,is that function thread safe ?

Hi everyone, My name is Emmanuel Katto. What performance tuning techniques have you found most effective when working with InterSystems IRIS? Any specific metrics to monitor?

I look forward to your tips/suggestions.

Thanks in advance!

Best,

Emmanuel Katto

In ObjectScript you have a wide collection of functions that return some value
typically:

set variable = $somefunction(param1,param2, ...)

There is nothing special about that.
But there is a set of functions that I classify as LEFT SIDED 
The specialty of them is that you can use them also on the left of the equal operator 
as a target in the SET command:

set $somefunction(param1,param2, ...) = value

The reason to raise that subject is that with IRIS 2024.1 there is after may years  a "new kid on this block"

$VECTOR()

We continue with this series of articles on LLM and RAG applications and in this article we will discuss the red boxed part of the following diagram:

In the process of creating a RAG application, choosing an LLM model that is appropriate to your needs (trained in the corresponding subject, costs, speed, etc.) is as important as having a clear understanding of the context you want to provide. Let's start by defining the term to be clear about what we mean by context.

What is context?

Hi, I'm working on a large extraction from a database and need to parallelize the processes during the extraction.

Here's what happens:

1. The user starts the extraction from.
2. Several jobs are started using the Job <Method> instruction.

At the end, the user expects to find a document containing the results of all the extractions. What I'd like to do is start a new job that checks whether the previously started jobs have finished or are still working and consequently produce the document.

Hi Team, we are going to deliver a speech on a developer forum where most developers hv not used our tech before but using other database and integration technologies , Pls give us some key points on why they should adopt us and the benefits you can get, especially if you change your tech stack from others to IRIS. Thanks a lot!

Hello everyone,

I'm working with a class generated by OpenAPI in InterSystems IRIS, specifically impl.cls. In one of the classmethods of this class, I need to switch to the %SYS namespace to access system-level functionalities and then switch back to the original namespace.

I tried using the following commands:

new $namespace
set $namespace = “%SYS”

However, these give an error when executed. Is there a proper way to change namespaces programmatically within a classmethod and gain access to the %SYS namespace? Any best practices or example code snippets would be greatly appreciated!

Thank you!

In the business world, every second counts, and having high-performing applications is essential for streamlining our business processes. We understand the significance of crafting efficient algorithms, measurable through the big O notation.

Nevertheless, there are numerous strategies to boost the performance of systems built on the IRIS Data Platform. These strategies are equally crucial for optimizing overall efficiency.

Let's join the journey for a sneak peek into the tips for making IRIS Data Platform work better, where every little trick will help your applications shine.

1. Using Indexes

Is there a simple way to compare Stream data between two objects?

We have used $ZCRC to create a checksum and that seems to be work.
We have also read each line of the streams and compared them and that seems to work too.

We just think there has to be a simpler way than looping through all the lines of the stream.

Any suggestions would be appreciated.

Motivated by personal feedback by @Edilson Eberle Carvalho  and an excellent presentation of @Michael Braam  related to Vector Search I'd like to sharemy personal approach to Vectors.When I started and met vectors with 256, 384, and over 1200 dimensions - I felt lost.However my example Vector-inside-IRIS - a simplification of iris-vector-search - worked fine. In order to understand the mechanics behind it, I decided to start in small steps.Our common 3 dimensions describe our physical world quite fine.Even the half 4th dimension (no negatives) added by Einstein is not to hard to follow.Cosmologic string theory

You have probably heard a lot about LLMs (Large Language Models) and the associated development of RAG (Retrieval Augmented Generation) applications over the last year. Well, in this series of articles we will explain the fundamentals of each term used and see how to develop a simple RAG application.

What is an LLM?

It has been asked a few times recently, how one can make Laravel Framework work with InterSystems IRIS Data Platform. It's been a while since this post about Laravel and InterSystems Caché was published. To bring it up to date, the article gives a brief instruction set on how to setup and configure a Laravel project for use with InterSystems IRIS through ODBC.

What is Laravel?

I have three different methods for exporting classes and projects as XML files, but each one produces slightly different output:

If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package.   
The rating reflects the experience of the reviewer with the status found at the time of review.   
It is kind of a snapshot and might have changed meanwhile.   
Reviews by other members of the community are marked by * in the last column.

I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix.    
Some were accepted and merged, and some were just ignored.     
So if you made a major change and expect a changed review just let me know.

We've recently made available a new version of InterSystems IRIS in the Vector Search Early Access Program, featuring a new Approximate Nearest Neighbor index based upon the Hierarchical Navigable Small World (HNSW) indexing algorithm. This addition allows for highly efficient, approximate nearest-neighbor searches over large vector datasets, dramatically improving query performance and scalability.

Managing InterSystems Servers – In-Person  October 28-November 1, 2024