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
2
votes
1 answer

How to set Schema in mybatis for IRIS databse

My Intersystem IRIS database contains multiple schema i.e. Each Developer has his own Schema. While accessing database from Spring boot application I am getting following error: [SQLCODE: <-30>:]\r\n[Location:…
DALJIT SINGH
  • 111
  • 1
  • 11
2
votes
2 answers

Testing data generator for Intersystems Caché?

Are there any easy ways (i.e. libraries) to create testing data for Caché, similar to the Populator and Faker gems for Ruby/Rails? ** edit ** I am trying to create test data for an Epic implementation. In addition to the electronic-medical-record…
craig
  • 25,664
  • 27
  • 119
  • 205
2
votes
1 answer

InterSystems IRIS Provider Communication link failure: System.Net.Sockets.SocketException in C#

I'm using VS Studio 2017 and InterSystems IRIS databases version 2019.1. When i'm trying to access database from code it will throwing below error: InterSystems.Data.IRISClient.IRISException: '[IRIS Provider] Communication link failure:…
Nayan Rudani
  • 1,029
  • 3
  • 12
  • 21
2
votes
1 answer

Linked server to Intersystems Cache database from MS SQL Server 2005 Browse Catalog

I'm trying to create a linked server in MS SQL Server 2005, pointing to an Intersystem Cache database via ODBC. Below is the query to create the linked server: /****** Object: LinkedServer [CC7] Script Date: 02/22/2011 09:06:39 ******/ EXEC…
George Duckett
  • 31,770
  • 9
  • 95
  • 162
2
votes
1 answer

InterSystems Caché Base64 XML Decode

In Intersystem Cache i export some GLOBALs using $system.OBJ.Export("GCL.GLB", "C:\GCL.xml") Now there is a field that is BASE64 encoded, for example the following…
Joey Erdogan
  • 184
  • 1
  • 13
2
votes
1 answer

Intersystems Objectscript, Persisted Class with Non Persisted Property

Can we create non persisted property inside persisted class. Simply do not save the property(column) with %Save()
Vivek Ranjan
  • 1,432
  • 2
  • 15
  • 37
2
votes
2 answers

How to escape reserved word (keyword) in InterSystems Caché SQL?

I have a column named Date in SQL table, but unfortunately this query throws an error: select Author, Date, Text from Tiny.Comment I've tried to escape the Date keyword with [Date] or 'Date' but this never worked for me.
ZitRo
  • 1,163
  • 15
  • 24
2
votes
3 answers

Intersystems cache: and error in Classes : How to solve AND avoid?

I have a single class in Intersystems Cache that writes records on the globals based on the user calling it Iterates on the globals and places results on a string Writes the said result to a notepad file via FILE However, a part of the code…
Malcolm Salvador
  • 1,476
  • 2
  • 21
  • 40
2
votes
0 answers

Possible to gather telemetry from InterSystems Cache using Microsoft Azure's Application Insights?

I'm working on an Azure Application Insights dashboard for a system involving an InterSystems Cache database. Is it possible to make Application Insights "aware" of a Cache database, in the way it's possible with our .NET code and other MS products…
TomK
  • 523
  • 2
  • 7
  • 18
2
votes
1 answer

Execute stored functions at run-time

I am trying to retrieve stored functions from a table and have them executed at run-time. Ex MyTableFieldValue contains: $PARAMETER(MyClass,MyParameterName) Where MyTableFieldValue is a field value in a table called MyTable. MyParameterName…
user6284097
  • 157
  • 1
  • 1
  • 9
2
votes
2 answers

Display %ROWCOUNT value in a select statement

How is the result of %ROWCOUNT displayed in the SQL statement. Example Select top 10 * from myTable. I would like the results to have a rowCount for each row returned in the result set Ex +----------+--------+---------+ |rowNumber |Column1 |Column2…
user6284097
  • 157
  • 1
  • 1
  • 9
2
votes
3 answers

Get corresponding rows in single line result?

Given the following data, how would I get the desired result below? Timestamp | Session ID | Event | Name ------------------------------------------ 08:15 | 89 | Login | Scott 08:16 | 89 | Edit | Scott 08:16 | 92 …
user736893
2
votes
1 answer

How do I apply string.Format to SQL Results?

In my application, I am querying the database, and would like to apply string.Format("{0:n}") to my results, so that the results have commas and decimals. However, I am having trouble getting it to work correctly. The code compiles, and everything…
Brian B.
  • 89
  • 11
2
votes
2 answers

Intersystems Cache: Embed SQL always returns only first row

I copied the code from off. documentation: &sql(SELECT *,%ID INTO :tflds() FROM Sample.Person ) IF SQLCODE=0 { SET firstflds=14 FOR i=0:1:firstflds { IF $DATA(tflds(i)) { WRITE "field ",i," = ",tflds(i),! } …
Nikita Vasin
  • 125
  • 1
  • 11
2
votes
1 answer

Comparing null values in Caché

I have this query: SELECT * FROM Ens.MessageHeader head ,EnsLib_HL7.Message as body WHERE head.MessageBodyId = body.ID AND body.Name IN ('ADT^A34','ADT^A40') AND MessageBodyClassName = 'EnsLib.HL7.Message' Which gives results like…
user736893
1 2 3
…
26 27