I've got a select statement bringing back one value, I want to combine all rows into one comma delimited string. So for example:

SELECT First Name

FROM mydb.People

I get a list of names:

John

Fred

Sarah

Carl

Jane

Julie

Instead of having 6 rows in the result, I want one row, with one cell that has "John,Fred,Sarah,Carl,Jane,Julie"

Is there a way to do that?

Hi dear Sir,

I see the DTL chain defined in IRIS, which is applicable if regarding transformation from one protocol to another, and fields/segments mapping:

Hi all! I just wanted to share a new video – the first in a series of three – addressing the migration from the InterSystems Private Web Server to an external web server. This video covers the process of installing a web server and upgrading your IRIS instance in a Linux/Unix environment. Two more videos on the way will show the process for a mirrored setup in Linux/Unix, and for a single instance in Windows.

Hi Community!

As announced in this post, next November 16 will take place the 1st meetup of the Spanish Developer Community. And registration is now open!

It is the first in-person event in Spain since the pandemic started and we are thrilled to reunite with our customers and partners. Are you in?

🗓 November 16, from 12:00 to 2:00 PM (CEST) + pizza & drinks

📍 The Westin Valencia Hotel

➡️ Click here for more details and registration >>

Note.- If you are already registered at the Iberia Summit and want to attend the Meetup, you have to register on the previous link too.

It's time to announce the Winners for September 2021! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in September 2021:

🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

🥈 @Muhammad Waseem, HIS Team Lead, International Medical Center, Jeddah, Saudi Arabia

🥉@Lorenzo Scalese, Solution Architect, Zorgi, Belgium

Learn more about the competition and our awesome winners below.

Discover how you can use the advanced interoperability features of InterSystems products in your system – now updated for InterSystems IRIS for Health! Interactive courses, hands-on exercises, and videos help you go from basic to advanced knowledge in just a few hours.

Hey Developers,

We're pleased to invite you to the upcoming "Development of Interoperability Business Hosts with PEX in Java/.Net" webinar by InterSystems Russia on July 16 at 10:00 (UTC+3, Moscow time)!

https://www.youtube.com/embed/ArSnkOthz8E
[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]

In my previous article, Using LIKE with Variables and Patterns in SQL, we explored how the LIKE predicate behaves in different scenarios, from Embedded SQL to Dynamic SQL, and what happens to performance when wildcards and variables come into play. That piece was about getting comfortable writing a working LIKE query. But writing SQL that works is only the starting point. To build applications that are reliable, scalable, and secure, you need to understand the best practices that underpin all SQL, including queries that use LIKE.

This article takes the next step. We’ll look at a few key points to help strengthen your SQL code, avoid common pitfalls, and make sure your SELECT statements run not just correctly, but also efficiently and safely. I'll use SELECT statements with LIKE predicate as an example along the way, showing how these broader principles directly affect your queries and their results.

*This is what Gemini came up with for this article, kinda cute.

References:

I have a DTL that calls a custom function that returns an object. How do I code the IF statement to check if the object is empty. e.g. IF tObject={}

InterSystems announces its third preview, as part of the developer preview program for the 2024.1 release. This release will include InterSystems IRIS^®, InterSystems IRIS^® for Health^TM, and HealthShare^® Health Connect.

Hi Developers,

We know that you're a sharing and caring bunch. Otherwise, you wouldn't be here and reading this 😉 And we'd like to remind you that we have other ways to stay in touch with our latest news, events, hot topics, etc.

Say hello to our official InterSystems Developer Community Social Media Channels!

I'm trying to execute SQL on a EC2 via SSM:

import boto3

instanceid = "i-123456789"
sql = """SELECT path FROM Security.Applications WHERE ID = '/csp/sys'"""
template = """su - irisusr -c 'cat << EOF | iris sql iris -U %SYS
                """ + sql + """
                        q
                        EOF'
                       """
template = [line.strip() for line in template.splitlines()] 
template = """\n""".join(template) 
ssm_client = boto3.client('ssm') 
response = ssm_client.send_command(
            InstanceIds=[instanceid],
            DocumentName="AWS-RunShellScript",
            Comment=AWS,
            Parameters={'commands': template})