Does anybody know if there is an easy way to know if the execution of the command $System.SQL.PurgeForTable went well/wrong?

The documentation describes that a string is returned, but in fact there is a nice Quit "" in the code.

Maybe inside PurgeForTable^%apiSQL there is any process variable set when it goes well/wrong?


Thank you very much!

0 5 96

Hi all,
By using VS code, I want to copy multiple files to local directory, then sync them to server, but I can't find where local directory is stored?
In Atelier IDE, I could open a view of server and can copy the code to the project, then code is saved in the local directory. When I copy multiple files to the local directory -> choose sync in Atelier -> the code will be synchronized to the server
How to do this from VS Code?

0 14 266

 We are using Native .NET API from IRISProviderCore21 package, inside .NET Core app, and having issue when trying to call function that takes instance of the class as parameter. The server is IRIS 2020.

 In a nutshell, the code looks like this:

            // Create instance of the parameter class, proxy object

            var paramObject = iris.ClassMethodObject("MyParameterClass", "%New") as IRISObject;

           paramObject.Set("property", "value");

0 2 106

Hey folks - I'm working on some training materials and I'm looking for a paragraph or two and/or a diagram that illustrates their record IO flow.  Does anyone know of a good outline of how records are moved into the database and committed?

0 2 113
neel Je · Nov 4, 2020
IRISReference in Native Api

I am trying to use IRIS Native API in .NET code I see following code snippet here

  IRISReference valueRef = new IRISReference(""); // set inital value to null string
  String myString = valueRef.value;               // get the method result

But IRISReference is not available as a type.

0 3 104

Hi All,

I'm being asked if I can set up a AWS EC2 containerised version of IRIS and a separate AWS EC2 installation of Apache to serve IRIS web files.

Creating the Apache EC2 and containerised IRIS EC2 is the simple bit but getting them both to talk to each other does not seem quite so simple and I cannot find any documentation to describe how this can be achieved.

Has anyone else managed to achieve this?


0 8 193

Hi, I am new to IRIS and We are planning to setup a CI pipeline on AWS VM deploying the iris data platform container. I am trying to find out which folders needs to be inside the source control and where (exact folder) the updated code needs to be pulled in the container. I would be much obliged if anyone cant point the CI CD related documentation.


0 1 168

Hi all, I am having problems trying to get Docker to run correctly on my Linux Mint machine.

I did the following:

1. Installed Docker.


docker --version

Docker version 19.03.6, build 369ce74a3c

docker-compose -v

docker-compose version 1.17.1, build unknown

2. Downloaded zip from

0 1 158
André Jouval · Aug 20, 2020
Programs and function cache


Do you know if cache has programs and functions cache

I made a backup of my production base and when I use this function abouve I receve an error, but if I change any letter of the command the function go ok.

Didn´t work


for this I.m using ODBC 64.


0 1 159

My VS Code plugin "InterSystems Objectscript" upgraded to version 0.8.7 but the server settings no longer visible in extension settings and can no longer connect to our InterSystems server.

What has chnaged and how do we set the server connectio up? I checked the JSON file and it still has the settings as it was before but it is not connecting.


0 2 199