SQL | InterSystems Developer Community

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 666

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

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 434

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 502

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 285