All time

I need to execute multiple DELETE statements in a single query like this

DELETE FROM TableName WHERE ID = 2;
DELETE FROM TableName WHERE ID = 3;
DELETE FROM TableName WHERE ID = 4;

However It does not work when there're more than 2 statements and gives me an error

Expected FROM found WHERE^DELETE FROM TableName WHERE

Using IN is not an option.

0 9
0 436
InterSystems Developer Community is a community of 25,368 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

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 https://github.com/intersystems-community/iris-fullstack-template/tree/42f9c174a9a4e63cb5eb3eb646abf3930a6e4d31

0 1
0 444

Hello!

Is there a way to create a custom ObjectScript formatting profile with Atelier?

I'm looking for something similar to the built-in controls provided with the Eclipse Java formatter.

0 4
0 441

After so many years of waiting, we finally got an official driver available on Pypi

Additionally, found JDBC driver finally available on Maven already for 3 months, and .Net driver on Nuget more than a month.

As an author of so many implementations of IRIS support for various Python libraries, I wanted to check it. Implementation of DB-API means that it should be replaceable and at least functions defined in the standard. The only difference should be in SQL.

And the beauty of using already existing libraries, that they already implemented other databases by using DB-API standard, and these libraries already expect how driver should work.

I decided to test InterSystems official driver by implementing its support in SQLAlchemy-iris library.

Open Exchange app
14 7
4 304
Article
· Sep 22, 2024 5m read
Database Management Tool

Introduction

Managing databases and performing CRUD operations are fundamental tasks for developers building data-driven applications. While many database management systems (DBMS) exist, they can be complex and cumbersome to interact with, especially when it comes to creating databases and tables, handling constraints, and performing real-time data operations through an API.

Open Exchange app
8 4
0 364

I'm trying to configure an SSL/TSL configuration in our test environment so we can send ADT messages to an external server. I've verified connectivity/firewall to the external server.

type is set to Client, Server certificate verification is set to Require.

I have received a certificate from the external supplier and linked that in the "File containing trusted Certificate Authjority certificate" field. (I've also imported it into the cert store and tried using %OSCertificateStore).

0 2
1 442

Is there a way to compare the content of two variables/ lists and if they share a common element/ value return 1?

Example the two below both have "Yellow":

Set y = "Red, Green, Orange, Yellow"

Set x = "Purple, Black, Yellow, Pink"

The lists I am working with have over 30 elements/values that vary so it is difficult to hard code it to say look for "Yellow".

0 12
0 432

Wondering if there's a setting in VSCode to stop continuting commenting in VSCode?

For example, if I have

//this is a comment

and press enter at the end, it will continue on the next line with

//this is a comment
//|

I would like to stop this behavior, or have it only continue with a block comment.

Is this possible in VSCode? I think it's part of the ISC extension that causes it, as it doesn't happen for other languages.

Thanks!

0 5
0 439

Hi team,

I'll start with an apology as I am trying to wrap my head around the architecture of how InterSystems IRIS database management works. I am attempting to connect to the platform remotely through say a JDBC or ODBC connection in order to run queries, searches (through SQL statements) on my laptop and was trying to understand whether this would be possible? It is possible to setup an inbound client connection and wanted to better understand the architecture of how the database association works for IRIS database management. Does it use it's own internal SQL database or are we able to connect to our own database and which databases are certified to run against the platform?

0 2
0 442

Is there a way to get a report of how many messages are passing through a production? I am trying to gauge how many messages we process weekly, monthly, and yearly. Also, over specific months.

Would appreciate if someone can guide me on this

We use Cache for Windows 2017.1.3

0 7
0 437

Hi Community,

New reward available on Global Masters Advocate Hub! Please welcome:

⚡️ Your Webinar supported by InterSystems ⚡️

Would you like to hold a professional webinar for developers and tell about your solution/tool and your company services?

Redeem this prize for 3,000 points and we will help you to organize it!

2 1
0 424

Hi,

I've setup an operation that pulls text from an MDM message and uses it to generate a csv file. I'm having issues as our vendor is sending the file with a carriage return (as shown below) to signify the next line but Healthshare is recognising this as a new segment which causes an error.

0 2
0 442

Hi,

I am new to FHIR resources here i need to store patient current location with patient resource but location resource does not linked with patient. I need help this. In FHIR R4 resources having separate i implemented successfully in my project but i am suffered how to link location and patient. I fount resources from https://www.hl7.org/fhir/resourcelist.html

My Code implemented by nodejs with typescript language here i added graphql instead of rest

0 3
0 441

I was writing a routine that called some class methods and when I typed in ##class( and the package, there was a drop down list of all the classes that match that package but when I selected one of the dropdown entries it added the package name again.

For example if I enter ##class(dim.

I am presented with a list of classes in the dim package but when I selected one of them,(dim.OccupationList), what ended up in the editor was

##class(dim.dim.OccupationList

1 1
0 443

InSync is an application currently under development by InterSystems, primarily using Ensemble, as a mixed CSP/Zen web application. There's a lot of defunct legacy code in the code base and we're actively seeking it out and trimming the deadwood out.

2 2
0 442

Attached to this post is a PDF document outlining some of the key enhancements included with 2016.2. I will be giving a WebEx session that is open to all tomorrow at 11 AM EST. Once the WebEx is over I will be adding a link to the recording for those who cannot attend.

2016.2 Field Test Launch
Tuesday, February 2, 2016
11:00 am | Eastern Standard Time (New York, GMT-05:00) | 30 mins

Meeting number: 747 673 229

Join!

4 0
0 444