SQL

About this tag

SQL is a standard language for storing, manipulating and retrieving data in relational databases

Subscribe to SQL content with RSS Syndicate content or email

I'm trying to get a count of specific message type with a specific entry and thought I could build the query in Message Viewer but  this does not provide counts (as far as I am aware).

Last answer 7 March 2018
2
1

answers

0

comments

98

views

0

rating

No doubt bitmap indexing, if used with a suitable property, performs just impressive!
But there is a major limit: ID key has to be a positive integer.

Last comment 17 February 2018
5
1

comments

172

views

+ 7

rating

I'm trying to learn how To use SQL in CACHE, so I hope I don't bore you with "Dumb" questions.... 

I'm getting "ERROR #6022: Gateway failed" message following this line of code. 

Last answer 14 February 2018 Last comment 12 February 2018
5
1

answers

4

comments

126

views

0

rating

Last week, we announced the InterSystems IRIS Data Platform, our new and comprehensive platform for all your data endeavours, whether transactional, analytics or both. We've included many of the features our customers know and loved from Caché and Ensemble, but in this article we'll shed a little more light on one of the new capabilities of the platform: SQL Sharding, a powerful new feature in our scalability story.

Last comment 31 January 2018
8
11

comments

592

views

+ 12

rating