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
3
votes
5 answers

How do you save the value of a global to a text file with Intersystems Caché?

In the terminal, I am printing the value of a global with zw ^MYGLOBAL. How do I save this output to a text file?
syonip
  • 2,762
  • 25
  • 27
3
votes
2 answers

What's the best practice to work with ENUM in Intersystems Caché?

Natively, Caché doesn't implement ENUMs such as Java for example, when you need to implement a solution like the following example in Java, but in Caché, what are the best practices? public enum Planet { MERCURY (3.303e+23, 2.4397e6), VENUS …
Lucas Boeing Scarduelli
  • 147
  • 8
3
votes
2 answers

C#/EF for Intersystems Cache

My background is more in C#/.Net, and have now been offered to move to Intersystems Cache. I haven't found any recent posts on this so unless I missed something here goes: From what I understand Cache has some mapping for ADO.NET/.NET, but is there…
CAR1980
  • 33
  • 5
3
votes
1 answer

Intersystems cache Object Script pass property as parameter by reference

Given: A class "A" with an %Integer property "intA" A class "B" with a classMethod foo(ByRef num As %integer) that gets a parameter byRef and does some calculations. And knowing that in caché Object Script: If you want to pass a parameter by ref…
matmat
  • 85
  • 9
3
votes
2 answers

Caché SQL columns to list

Do you know of any way to create the Result set below in a single SQL statement? Record Set: ID AC9 Value 1 11111111 A 2 11111111 B 3 11111111 C 4 11111111 D 5 22222222 B 6 22222222 C 7 22222222 D 8 …
Chad Johnson
  • 65
  • 1
  • 5
3
votes
2 answers

Try-Finally Equivalent in Caché ObjectScript

I'm looking for the equivalent semantics to the popular Try-Finally exception cleanup pattern, e.g. Why use try … finally without a catch clause? The idea is that you have cleanup steps that need to happen regardless of whether the code succeeds or…
Chris Smith
  • 5,326
  • 29
  • 29
3
votes
2 answers

How to check a column exists in a table in Intersystems Cache SQL?

I've noticed that while I can use %dictionary.compiledclass to get a table with schema names and table names, which allow querying for their existence, I cannot do the same for columns. I have yet to find the command that allows verifying whether a…
Ahab Lollington
  • 31
  • 4
3
votes
6 answers

InterSystems Caché - How to get access to Caché Studio?

I am a Caché admin so I have have all access to the system managment portal. I would like to use Caché studio but my login doesn't seem to be setup properly for that. I am new to Caché, only been using it for 2 months now, I am learning the Jargon.…
JIM GAUL
  • 31
  • 1
  • 3
3
votes
1 answer

Using IDLocaltion Attribute in a cache sql storage map

I have an Index global (XWES.ETI) that I want to use to pull subscripts for anther table. The XWES.ETI global has a single subscript (a sequentional number) and has two pieces of data that I want to use as subscripts for actual global defined in the…
Fred Altman
  • 221
  • 1
  • 2
  • 5
3
votes
2 answers

How to use Java Methods with Caché?

I recently read that it is possible to use Java methods in a class by using the language attribute. I tried this: Method JavaTest() As %String [ Language = java, WebMethod ] { string tmp = "Hello World"; return tmp; } The code compiles, but…
O.O
  • 11,077
  • 18
  • 94
  • 182
3
votes
1 answer

How to create a unique GUID in intersystem's cache?

Looking through the documentation I don't see a GUID datatype. Is there a function or something to generate a random GUID? What is it?
O.O
  • 11,077
  • 18
  • 94
  • 182
2
votes
3 answers

Type checking on Caché Objects

What is the point of type definition on method parameters on Caché Object (from Intersystems) since after it's pre-compiled to the .int format, it removes any typing information, thus making no difference at all?
Francisco Fiuza
  • 421
  • 1
  • 5
  • 4
2
votes
2 answers

How to "throw" a %Status to %ETN?

Many of the Caché API methods return a %Status object which indicates if this is an error. The thing is, when it's an unknown error I don't know how to handle (like a network failure) what I really want to do is "throw" the error so my code stops…
Marc Stober
  • 10,237
  • 3
  • 26
  • 31
2
votes
1 answer

How to keep external applications in synch to intersystems instance of a mirror

Our application is built on top of Intersystems IRIS (previously cache) and consists of a large core and DB that is enhanced with several external modules that connect to the core. We deploy IRIS and the external apps on premise on the same server…
Mathew
  • 41
  • 5
2
votes
0 answers

Pyodbc error when trying to connect to DB

I'm trying to connect to a DB using pyodbc. This is my code: import pyodbc as db c_str = r'DRIVER={InterSystems ODBC35}; ' + 'SERVER={0}; PORT={1}; DATABASE={2};' \ 'UID={3}; PWD={4};…
leyjl2
  • 29
  • 2
1 2
3
…
26 27