SQL | InterSystems Developer Community

Question

Benjamin Eriksson · Mar 7, 2016

Hello!

I'm trying to run a simple SQL query in atelier but it complains about the manager. I'm not sure if this is the best way to do it but here is what I got so far:

#Development Environment #SQL #Caché

1 5

0 358

Question

Jeffrey Semmens · Mar 3, 2016

Load balancing multiple Ensemble operations to handle bulk load of data

What is the recommended approach to handle the following scenario: Large number of HL7 messages are serviced via Ensemble. Those messages are then transformed and routed to an Operation which calls a web service which does a number of different activities. If will do address normalization, location geo coding, MPI lookup and resolution, and insert into a SQL Server database to stage for an analytics product. Unfortunately all of this work takes time and the first thing that happens in the web service is a lock taken out on the Patien in SQL Server.

#Ensemble #HL7 #SQL

1 2

0 662

Question

Scott Beeson · Feb 16, 2016

Concatenate columns in results with GROUP BY?

Here is my original query:

SELECT EventType, InitiatedAt, COUNT(*) as cnt
FROM HS_IHE_ATNA_Repository.Aggregation
WHERE EventType = 'LOGIN'
AND LocalDateTime > '2016-02-16 11:00:00'
GROUP BY EventType, InitiatedAt

This gives me data like this:

#Code Snippet #Databases #SQL #Caché

0 3

0 6.8K

Question

Timothy Leavitt · Feb 9, 2016

Property with SqlComputed and SqlComputeCode, but not Calculated or SqlComputeOnChange

Looking at a property defined as follows:

#Object Data Model #ObjectScript #SQL #Caché

1 4

0 662

Question

Blaise ZARKA · Feb 4, 2016

How to export SQL errors to a text file?

Hi,

Do you know how to export SQL errors to a text file from a terminal session in Caché?

Thanks

#Caché #SQL

0 3

0 381

Question

Andreas Östlund · Jan 25, 2016

Getting number of processed messages of all productions

Hi!

Is there any simple way to query data about processed messages in all Ensemble productions?
What I ultimately would like to do is to periodically export that data to another system and run statistics on it.

I've been digging around in the SQL tables view and Ens.MessageHeader seems to contain most of what I'm after.
Using ODBC I could access that table view and query data, but only for one namespace per DSN it seems.

#Ensemble #ODBC #SQL

0 5

0 498

Question

Pravin Barton · Jan 20, 2016

Use an array as a SQL parameter for a Zen tablepane?

I'd like to have an array as a parameter for a SQL 'WHERE... IN' statement. The array would be modified in javascript on the browser. Here's a simplified example:

#SQL #Frontend #ZEN #Caché

1 2

0 424

Question

Scott Beeson · Jan 13, 2016

Best way to retrieve specific record?

New to CSP and Zen. I've been going through tutorials and have made some progress. Using the "Contacts" tutorial as an example, I'm trying to create a "ViewContact" page. I want this to be linkable so I'm using URI Parameters, which I understand. However, what I'm not sure about is how to retrieve a specific record. Should I use a SQL statement? If so, how?

#SQL #Tutorial #Frontend #CSP #ZEN #Caché

0 5

0 284