SQL | InterSystems Developer Community

Question

Hello all,

I need help with coming up with a SQL query that pulls only one value. I have a case where two providers share the exact same name. Each has a different NPI number and IdentityTypeId. I tried the below query - output is also below.

#SQL #InterSystems IRIS for Health

0 18

0 71

Question

KEVIN TAYLOR · Sep 17

Stored procedure for insert into and select from tables

How to add the following to a stored procedure (Cache Studio)
1. Select from a few tables and insert result into a TABLEA.
2. Then select data from the TABLEA, apply some SQL logic, insert results into TABLEB.
3. SELECT * FROM TableA
UNION ALL
SELECT * FROM TableB

#SQL #Caché

0 7

0 100

Question

Scott Roth · Oct 2

BP/External SQL Calls are creating IRIS.WorkQueue but is not purging the global

I have been trying to track down an issue we are seeing in our TEST environment with Memory usage.

We have Several BP's for years now that take a HL7 message, parse it apart, and make calls to a Custom EnsLib.SQL.OutboundAdapter to have it execute Insert/Select/Update/Delete stored procedures against a MS SQL Database via JDBC connection. We are using Microsoft's JDBC 12.2 driver to do this.

What we are seeing is that IRIS.WorkQueue globals are being defined for these calls but then the IRIS.WorkQueue is not being cleaned up and taking up large amounts of Memory.

#Business Operation #Business Process (BPL) #Globals #HL7 #JDBC #SQL #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS

0 5

0 34

Question

Andreas Schneider · Sep 15

Have you tried the THROUGH command in IRIS 2024.2? How does it work?

Has anyone successfully tested the new THROUGH command in IRIS 2024.2 with a FOREIGN SERVER?https://docs.intersystems.com/iris20242/csp/docbook/Doc.View.cls?KEY=RSQ...

I have connected from a Docker instance to a VM. I was able to successfully set up the JDBC connection through the UI.

#JDBC #SQL #InterSystems IRIS

0 3

0 183