SQL | InterSystems Developer Community

Question

Patrik Spisak · Nov 28

I have issue with one of my queries. That query work fine for ages, but suddenly stop works and giving me SQLCODE 100 in the routine.

#Management Portal #SQL #InterSystems IRIS

0 2

0 95

Question

Nimisha Joseph · Dec 2

Issue with Parameterized Queries in EnsLib.SQL.OutboundAdapter - Ensemble

Hi everyone,

I’m using EnsLib.SQL.OutboundAdapter in my InterSystems Ensemble operation to execute an insert statement in Sql Server Management Studio 20. While inline queries (e.g., constructing the query string with _ concatenation) work fine, I'm facing issues when trying to use parameterized queries.

Serialized JSON: {"CHI":"2894","Forename":"Janis"}

#SQL #Ensemble

0 10

0 73

Question

Dmitrij Vladimirov · Nov 22

Calculate STD DEV with ObjectScript

Hence the question: is there a way to do that?

The goal is to get data (from half a thousand to 3-4 thousands lines) from DB, calculate standart deviation then use it as logical condition in analyzer.

For example IF std > custom_value = show_the_result ELSE null

There is a STDDEV(MDX) method used in Analyzer but it is a measure and it can not be used as logical condition (correct me if i am wrong)

#Analytics #Analyzer #MDX #ObjectScript #Python #SQL #InterSystems IRIS

0 2

0 57

Question

Scott Roth · Dec 9

Foreign Server/Table Help

I am attempting to create a Foreign Server/Table so I can pull some information in from MS SQL server via JDBC connection, but as soon as I create the Server/Table and logout the Foreign Server disappears.

CREATE FOREIGN SERVER Epic.Clarity 
   FOREIGN DATA WRAPPER JDBC CONNECTION 'MS-EpicClarity'

logout, then run

#SQL #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS

0 1

0 33