I'm trying to make a connection to an external database using %SQLGatewayConnection, but the connection always fails. DSN properly configured. I try to make the same connection through isql in bash, and the connection is successful.

This same connection fails in Caché.

I have a business service which is responsible for some batch operations with an SQL table. The process is generally slow but it is possible to scale the performance using multithreading and/or parallel processing and logical partitioning (postgres):

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Security In the Cloud - Assuring a Secure InterSystems IRIS Cloud Overlay @ Global Summit 2024

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

I am leveraging the cloud storage adaptor to upload objects to an S3 bucket. I now need to add Tags to the object, but I don't see any mechanism within IRIS to allow adding of Tags.

Is that functionality currently available?

Hi Community,
We invite you to join our next Meetup in Cambridge, MA on August 28, 5:30-7:30 pm.
>> RSVP here <<

How to send the HL7 Batch messages over a SOAP webservice which takes 3 credentials(Username, Password& Org.ID) using IRIS Management Portal V 2019.1?

WSDL xsd : element - 1.Username , 2.Password ,3.Org.ID ,4.HL7 Message.

Info I had -

Source is CSV File will be translated to HL7 using data Transformations. All the transformed messages need to be sent to destination System through SOAP request as a single Batch File.

It's true! QuinielaML has incorporated the most important leagues in Europe (and Brazil) into its prediction service, so, dear members of the Developer Community, wherever you are from, you will be able to have the predictions of your favorite leagues at your disposal.

From the predictions screen you will have access to each of the new leagues included, being able to record the matches for each journey:

What advice would you give someone who is new to IT?

Someone who wants to become a developer?

Which code to start learning first?

Hey Community,

We greatly appreciate all your feedback on the InterSystems Python programming contest. Please take a few questions to help us improve our contests.

👉 Quick survey: InterSystems Python Contest Survey

Hi Community! Many of you have seen the Data Points podcast episodes that we have been releasing since February. I mentioned previously that I planned to pose an open question to the community about topics you might like to hear in a podcast episode. Let us know in the comments if there are any conversation points you would find particularly interesting, and we can try to include some conversations with experts on said topics!

And in case you missed it, check out Episode 12 about the all-new chat bot on InterSystems websites!

https://5e18edf067eb59-03854285.castos.com/player/212752
[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]

I have dynamic sql select query ,

Set resultset = ##class(%ResultSet).%New()

set sql = "SELECT COUNT(*) FROM "_tableName_" WHERE "_fieldName_">='"_fromDate_"' AND "_fieldName_"<='"_currentDate_"'"

SET SC = resultset.Prepare(sql)

SET SC = resultset.Execute(sql)

How can I print/view the count ?

I am trying to create a HS.FHIR.DTL.vR4.Model.Resource.Encounter message based on a conversion of HS.FHIRServer.Interop.Response QuickStream to a JSON %Dynamic Object.

When I try to send the HS.FHIR.DTL.vR4.Model.Resource.Encounter onto the Router

Hi,

I see the following error when importing the Custom ASTM Schema in ASTM SCHEMA STRUCTURE page of Management Portal.

ERROR #6301: SAX XML Parser Error: zfieldDescToName+1^EnsLib.EDI.ASTM.SchemaXML.1 while processing MY_PATH\LCA1394_Schema.AST at line 8 offset 80

The line 8 is copied from ASTM E1394

Any advice?

-William

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.