Stack Overflow
Stack Overflow

Questions tagged [intersystems-cache]

Caché is a multi-model DBMS and application server developed by InterSystems.

Caché is an multi-model (object, relational, key-value) DBMS and application server developed by InterSystems.

InterSystems Caché provides several APIs to operate with same data simultaneously: key-value, relational, object, document, multidimensional. Data can be managed via SQL, Java, node.js, .NET, C++, Python. DBMS Caché has proven embedded technologies for horizontal scaling (ECP, SLM), High Availability (Mirroring), transaction support and backup. It includes embedded Caché ObjectScript language which is back compatible to and which helps to run applications' business logic close to the data and achieve maximum performance for complex logic operations with data. Caché also provides application server which hosts web apps (CSP), REST, SOAP, web sockets and other types of TCP access for Caché data.

It is commercial software sold to application partners that develop end user applications.

More information can be found in Wikipedia: http://en.wikipedia.org/wiki/InterSystems_Caché

Official website: http://www.intersystems.com/cache/index.html

InterSystems Developers Community blogs can be found here at https://community.intersystems.com/?filter=articles

3rd party solutions and examples could be found on InterSystems Open Exchange https://openexchange.intersystems.com/

396 questions
4
votes
1 answer

Redirect current IO device for 3rd party routine interaction

I have many vendor supplied M-Code routines as part of a much larger product that use READ and WRITE directly to interact with the current device. I can't change that code. I want to wrap some of those routines in a system where I can supply input…
Chris Smith
  • 5,326
  • 29
  • 29
4
votes
3 answers

External IDE for InterSystems Caché

I want to replace the Caché Studio, because it needs to be ran on Windows. Browser based IDE would be most convenient solution for using OS indepedently and mobile. Is there any browser based IDE for use with InterSystems Caché database?... ...Or,…
besq
  • 155
  • 1
  • 2
  • 7
4
votes
1 answer

Running ObjectScript programs against Intersystems Cache to provide data with SQL Server

Background The main application where I work is based heavily on the MUMPS-esque Caché database engine from InterSystems. Everything is stored in global arrays. Getting data out of the system for external reporting ranges from simply being a pain to…
Chris Smith
  • 5,326
  • 29
  • 29
3
votes
1 answer

Unexpected SQL error returns in Intersystems Cache

Problem I'm working on exporting data from an Intersystems Cache database through the Cache ODBC Driver. There is a particular table that is giving me an error message. The ODBC Driver crashes and reports an error from the Cache system. I think I…
avanschoyck
  • 71
  • 6
3
votes
2 answers

mybatis foreach but submiting individual inserts

The following mybatis mapping works on all our supported databases except for one. This is because that database does not allow a bulk insert method (Intersystems Cache). Because of that I'd like to submit individual insert statements instead…
RailRhoad
  • 2,128
  • 2
  • 25
  • 39
3
votes
1 answer

How to make Intersystems Caché use the new compiled class instead of the older one?

I'm having trouble with loading and compiling a new version of existing classes. At the time they are loaded, there aren't any references in use to them. Class "Test.Extended" extends class "Test.Base". Class "Extended" calls a ClassMethod on class…
Luis Soeiro
  • 4,262
  • 6
  • 35
  • 45
3
votes
3 answers

SQL Percentage calculated dynamically

How to calculate percentage dynamically in SQL? Let's say you have a following table called Classes: ClassSession StudentName --------------------------------- Evening Ben Morning Chris Afternoon Roger Evening …
Joshua Spens
  • 49
  • 7
3
votes
2 answers

LEFT JOIN on static list of items?

DBMS is intersystems-cache! Motivation: I need to do a left join on a table so I can get the same list of message types every time, even if the result is zero or null. Unfortunately, this is a large table so including a SELECT DISTINCT() is…
user736893
3
votes
2 answers

Unexpected result from COUNT query

I am experiencing a weird problem while getting count from one table. The table name is Client and there is a varchar(200) column named CardNo. The database engine is Intersystems Cache and the querying syntax is SQL. I execute queries below to get…
Ahmet
  • 85
  • 1
  • 8
3
votes
2 answers

Difference between two date time stamp in Intersystems Cache

I would like to find out the number of hours and minutes between two date time stamp. if for example sDateTime = 2016-01-01 01:00 eDateTime = 2016-01-03 02:30 I would like it to output it as 49:30 (49hours and 30minutes) I am unable to figure…
jk1844
  • 327
  • 1
  • 5
  • 12
3
votes
1 answer

Intersystems Cache - How to Enable/Configure Security Services

Looking to create a script that will enable/configure snmp and related settings. Through the web portal it would be placed in: [Home] > [Security Management] > [Services] > Service_Monitor Would like to be able to enable, add allowed IP Addresses,…
user443709
  • 31
  • 1
3
votes
2 answers

Optimal way to search for an object by using a unique value of one of it's properties

I have an object with a property that has unique values. It might not be a good reason, but this property isn't my ID because it is a list, and the display value consists of non-printing characters. I would like to check for existence of an object…
neManiac
  • 181
  • 1
  • 7
3
votes
1 answer

What is the difference between ByRef and Output method argument modifiers?

All is in the subject, really. I fail to see what the difference in behavior is between those two methods for x: // first version Method m(ByRef x As whatever) { // play with x } // second version Method m(Output x As whatever) { // play…
fge
  • 119,121
  • 33
  • 254
  • 329
3
votes
1 answer

Anyone use SonarCube with ObjectScript

We use InterSystems Cache which has a development language called ObjectScript (kinda looks like VB). It has it's own IDE called Studio. Has anyone been able to successfully use SonarQube with Studio/ObjectScript? There is no plugin for it. Thanks…
IamSpartan87
  • 31
  • 2
3
votes
1 answer

JSON data against DeepSee MDX queries in InterSystems Caché

I want to retrieve JSON data against MDX queries on DeepSee OLAP cubes in InterSystems Caché. Any ideas?
Evgeny Shvarov
  • 468
  • 5
  • 17
1
2
3
…
26 27