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

Article

Steve Glassman · Feb 19, 2016 1m read

2016.2 Field Test Kit 2016.2.0.595.0

I am pleased to announce the next 2016.2 field test kit, 2016.2.0.595.0.

It may look like a slow week, with less than fifty changes having been checked in, but this kit includes the following fixes to problems found by you, the ones running the kits in the field:

#Caché #Data Model #Document Data Model (NoSQL) #JSON #SQL #Field Tests

3 0

0 279

Announcement

Andreas Schneider · Feb 17, 2016

Caché Monitor - A database tool primarily for InterSystems Caché allows sql queries across namespaces

Caché Monitor is a database\sql tool primarily for InterSystems Caché but can also connect to MS SQL Server, MS Access and more databases. Within Caché Monitors Server Navigator you see all available Namespaces on your Caché Servers. No need to know the name of the Namespace, no need to configure many many JDBC Connections by hand. Just click on the namespace and see all objects like tables, views, classes and more...

#Databases #Development Environment #SQL #Tools #Caché

3 2

0 2.4K

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 661

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 380

Article

Kyle Baxter · Feb 2, 2016 1m read

Creating an IDKEY with a chosen name

What do you do if you want to have the ID field have a meaningful name for your application?

Sometimes it comes to pass that when you're making a new table that you want to have the unique row identifier (a.k.a. IDKEY) to be a field that has a name that is meaningful for your data. Moreover, sometimes you want to set this value directly. Caché fully supports this functionality and it works Suppose you have a class Test.Kyle. The data will be stored like so:

^Test.Kyle(IDKEY)=$LB("",Field1,Field2,...,Fieldn)

#Object Data Model #SQL #Caché

3 2

0 432

Announcement

Bill McCormick · Feb 1, 2016

Caché 2016.2 Field Test Preview & WebEx Invitation

Attached to this post is a PDF document outlining some of the key enhancements included with 2016.2. I will be giving a WebEx session that is open to all tomorrow at 11 AM EST. Once the WebEx is over I will be adding a link to the recording for those who cannot attend.

2016.2 Field Test Launch
Tuesday, February 2, 2016
11:00 am | Eastern Standard Time (New York, GMT-05:00) | 30 mins

Meeting number: 747 673 229

Join!

#Caché #SQL #System Administration #Field Tests

4 0

0 394

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

Article

Alexander Koblov · Jan 29, 2016 9m read

Creating a Custom Index Type in Caché

The object and relational data models of the Caché database support three types of indexes, which are standard, bitmap, and bitslice. In addition to these three native types, developers can declare their own custom types of indexes and use them in any classes since version 2013.1. For example, iFind text indexes use that mechanism.

#Best Practices #Databases #Indexing #Object Data Model #SQL #Caché

12 1

1 2K

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

Article

Developer Commu... · Oct 21, 2015 1m read

20X Faster SQL. How Does Caché Do That?

Customers who switch to Caché from relational databases report that their average performance is up to 20 time faster, running on the same hardware, with no changes to the application. What is it about Caché that lets applications run so fast?

#Caché #SQL

0 0

0 237

Article

Developer Commu... · Oct 21, 2015 1m read

Fighting Impedance Mismatch at the Database Level

Introduction

With the maturation and wide acceptance of Java, object-oriented programming has moved to the foreground of the application development landscape. Because of their rich data models and support for productivity-enhancing concepts such as encapsulation, inheritance, and polymorphism, object technologies like Java, C++, and COM, are favored by today's application developers.

#Caché #SQL

0 0

0 194

Article

Developer Commu... · Oct 21, 2015 1m read

Oscillating Between Objects and Relational:The Impedance Mismatch

Introduction

Impedance mismatch is a term commonly used to describe the problem of an object-oriented (OO) application housing its data in legacy relational databases (RDBMS). C++ programmers have dealt with it for years, and it is now a familiar problem to Java and other OO programmers.

#Caché #SQL

2 0

0 271