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
8
votes
7 answers

Version control for InterSystems Ensemble/Caché

I'm in a group which is starting to develop using InterSystems Ensemble (an integration framework built on top of InterSystems Caché). InterSystems has not made the Ensemble Management Portal source-control-aware and this seems a source of problems…
fglez
  • 8,422
  • 4
  • 47
  • 78
6
votes
3 answers

How to set a variable to NULL in ObjectScript?

In c# I can do: object foo = null; How do I do this in object script?
O.O
  • 11,077
  • 18
  • 94
  • 182
5
votes
4 answers

Intersystem Cache and MongoDB comparision

wanted to understand how, the intersystems Cache and Mongo Databases are different from each other. In couple of threads in the stackoverflow itself it has been mentioned that there are no differences as such between Object database and NoSQL…
Ayusman
  • 8,509
  • 21
  • 79
  • 132
5
votes
1 answer

Issues with output while connecting using nodejs mssql

I'm new to node.js and I'm trying to connect to a intersystems-cache database. Here is what I have, based off the sample code in the docs: var sql =…
user736893
5
votes
4 answers

ROW_COUNT Equivalent for Intersystems Cache?

I have a query I need to run that returns the most recently updated row for each client. In SQL Server, I would do the following: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (PARTITION BY client_id ORDER BY date_updated DESC) AS rn FROM…
Alex Bello
  • 199
  • 2
  • 20
5
votes
1 answer

how to obtain a list of schemas in intersystems cache?

I'm connecting to a Caché database using the ODBC driver, and I want to do a query to obtain a list of schemas. In Microsoft SQL Server I can use a query like this: SELECT * FROM INFORMATION_SCHEMA.SCHEMATA How can I do this in Caché? I'm also…
Rn222
  • 2,167
  • 2
  • 20
  • 36
4
votes
2 answers

What is the current preferred method for enumerating the globals in a namespace?

I used to look at the source for %G for this, but lately Intersystems has stopped distributing the .INT code. I guess in theory I could use an eXecute statement in a loop to check $D on every legal global name but that's silly and unreasonably…
psr
  • 2,870
  • 18
  • 22
4
votes
7 answers

Export from Intersystems Caché database

I have a product based on Intersystems Caché database, I can see no classes, no schemas, no tables, only globals. Is there any smart way to export data from these globals and get "human-readable structure"?
Martin
  • 41
  • 1
  • 2
4
votes
3 answers

Continuous Integration for Intersystems Cache solutions

I am starting a project from scratch using Intersystems Cache. I would like to setup a Continuous Integration Server for the project. Cache has unit test libraries, so the idea is to import source into a test database, build the source, run unit…
Raymond Roestenburg
  • 4,890
  • 2
  • 20
  • 18
4
votes
2 answers

Return 0 in GROUP BY when COUNT(*) is NULL

Here is my original query: SELECT CAST(IndexedDate as varchar), COUNT(*) AS Logins FROM Table WHERE EventType = 'Login' AND IndexedDate > DATEADD(mm, -1, GETDATE()) GROUP BY IndexedDate ORDER BY IndexedDate DESC This would…
user736893
4
votes
1 answer

Base64 encoding and decoding using Caché Object Script

Is there any "built-in" methods or ways to encode/decode to/from BASE64 string in Caché?
ZitRo
  • 1,163
  • 15
  • 24
4
votes
1 answer

Caché Object Script Code guidelines

I work with InterSystems Cache and look for Caché Object Script coding guidelines. Does someone have any example?
Evgeny Shvarov
  • 468
  • 5
  • 17
4
votes
0 answers

NPEs trying to get MethodDefinitions out of ClassDefinitions; how to diagnose?

Environment: the caché server is a x86_64 SuSE Linux Enterprise server; installation is, as far as I can tell, some 2014.x version; I have SSH access to the machine, but nothing web (VPN, ya know); the client side is a Debian Jessie machine; the…
fge
  • 119,121
  • 33
  • 254
  • 329
4
votes
3 answers

Compare strings in Intersystems Cache Objectscript

Given: 2 strings strA, strB I want: To perform a comparison between them and return <0, =0 or >0, in Intersystems Cache ObjectScript. So far: I have found a function in the documentation that fulfills my needs StrComp. Unfortunately, this function…
matmat
  • 85
  • 9
4
votes
2 answers

How to query Intersystems Caché for a list of namespaces, databases, and tables?

I need to obtain a list of namespaces, databases, and tables in Caché so I can loop through each and query various things (like row counts). I've seen this, but it only lists the databases within the %SYS namespace. I know I can use LIST^%NSP in…
user2063351
  • 503
  • 2
  • 13
  • 31
1
2 3
…
26 27