Hi everyone

when I use JDBC(Version:intersystems-jdbc-3.8.0.jar) to connect to the Iris(Version: 2021.1.2.338 xDBC Protocol Version 63)

I’m trying to execute SQL statements that include double quotes, but unfortunately, they’re failing.

For example:

[this query]

SELECT count(*) AS "_pfgnrtd_0" FROM "BILL_COM_PO"."PrintLog"

[Error ]

0 3
0 117
InterSystems Developer Community is a community of 22,346 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!

Hi,

I created a property in a Business Process class and added that property to the "settings" parameter to display it as a field in production settings.

Property ServerName As %String(MAXLEN = "");

Parameter SETTINGS = "ServerName:Server Config";

Property names cannot contain characters such as underscore or whitespace. Is there any way to change the display name in production so that I can show this setting as "Server Name" and not "ServerName"?

0 3
0 117

Hi Community!

How can you create a balanced approach to using Generative AI? Get help from InterSystems experts in the latest video from Learning Services:

Weighing the Benefits and Risks of Generative AI

https://www.youtube.com/embed/VaUS5M0S0hY?utm_source=youtube&utm_medium=social&utm_campaign=VaUS5M0S0hY
[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]

1 0
0 120

Hey Developers,

Watch the latest video on InterSystems Developers YouTube:

Identifying Structured and Coded Data in HL7 FHIR Resources

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

0 0
0 120
Article
· Feb 3 3m read
SQL Host Variables missing ?

Host Variables are a rather common programming feature in many implementations of SQL.
A recent question in DC made me aware that in IRIS, Caché, Ensemble, ...
host variables just exist within embedded SQL

> You can supply host variables for Embedded SQL queries only. <

Related examples are included in the available Documentation

This is a description for a workaround if you don't / can't use embedded SQL.

9 0
0 119

We connect to MS SQL Databases using the Microsoft JDBC Driver 12.2 using the following URL

jdbc:sqlserver://<server>:<port>;database=<database name>;trustServerCertificate=true;integratedSecurity=true;authenticationScheme=NTLM;domain=osumc;authentication=NotSpecified

They want to migrate the databases to the Azure Cloud and in doing so we need the Authentication to change to go through Microsoft Entra. I was given the following URL

0 5
0 114

Hey, So the title pretty much describes the question:
Where and How can i see the Stream that contains the response back to the client of a CSP application.

When the request is being processed and finished we return a response to the client - We do that by writing the data to a stream and that stream is sent back to the client.
I wanted to know how i can access the point right before that Data is actually written to the client back (meaning the place where the response is actually being send back, the last point of contact).

0 9
0 110
Question
· Aug 28, 2024
COMPARE ROUTINES

IS IT POSSIBLE TO COMAPRE TWO ROUTINES ACCROSS INHOUSE NETWORK AND IF SO THEN WHAT IS THE PROPER SYNTAX TO USE?

SAMPLE:

K ^RICH D ##class(%Library.Routine).RoutineCompare("\\IP\C$\.......\$NAMESPACE","RTN","\\LOCALHOST\..........\$NAMESPACE","RTN","^RICH")

1 2
0 117

Hi Community!

We're super excited to invite you to the LinkedIn Live event dedicated to online learning!

🌐 Two Decades of Innovation in Learning and Development 🌐

📅 Thursday, May 30, 10 am ET | 4 pm CEST

🗣 Presenters:

https://www.youtube.com/embed/5iVApYu7YjM?si=Ae5NBCHdWSxhWewn
[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]

2 1
0 99

Hi Community!

Thank you to everyone who participated in the "Help Us Improve the DC Search" sweepstakes! Your feedback is invaluable in making the Developer Community better, and we will use it to improve our search. Now, it's time to announce the winner - watch the video to see the sweepstake drawing:

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

4 0
0 118

Intersystems provides External language server connections for various languages which,
from a development perspective, is great as I can keep my application code separate but still interact with the IRIS kernel.

It becomes more complex though if you are using Interoperability etc where you might end up with some code in IRIS and some code in another language.

What would be great is having an IRIS to IRIS language server where the application code and stay IRIS based but separate from the database?

0 5
0 113

Hi Community,

Watch this video to learn about the latest developments and what to look forward to in InterSystems IRIS:

InterSystems IRIS: What's New & Next @ Global Summit 2024

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

1 0
0 118

I'm running into an intermittent issue with some of our Custom Operations/Processes as a result of some large FHIR R4 Binaries. Essentially we get a response from an AthenaHealth FHIR endpoint that appears to be too large to be processed using the IRIS Built In Functions for FHIR:

I've replicated it on the command line here using a file (binary.json) that has the response from the FHIR Endpoint. Not sharing full contents due to PHI concerns.

0 1
0 117

Our target system requires a blank ROL segment whenever the ROL segment does not exist in an A08 from our source system. I'm not sure if this can be done with the DTL gui tools or if some sql or other code is required (coding is not in my wheelhouse). Here is what I've tried, but this does not yield the "ROL|1|" I'd like to create. Any help would be greatly appreciated.

Here is the input message that I'd like to add the ROL segment to:

1 5
0 112

Hey Community,

Enjoy the new video on InterSystems Developers YouTube:

Creating an InterSystems IRIS Cross Functional App in 150 Lines of Code @ Global Summit 2024

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

1 2
0 77

InterSystems has corrected a defect that causes invalid database and journal records to be introduced when using a specific $LIST syntax. The likelihood of encountering this defect is very low but the operational impacts can be significant.

3 0
0 117

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

InterSystems Package Manager @ Global Summit 2024

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

1 0
1 117