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
0
votes
2 answers

How to get list of stored procedure in a namespace of Caché database using a query?

How to get list of stored procedures available in a namespace from an Intersystems Caché database using query?
Krishnamuthu
  • 61
  • 6
0
votes
1 answer

Keep the values of a complex type property in a Zen Page

I am trying to keep the values of a Zen Page's property, that is an array of a complex type, but I am not having success. When I set an object in this array and the method when I am doing this finishes, the array is cleared. The same does not happen…
Marcelo Neppel
  • 3
  • 2
0
votes
1 answer

how to call a simple java program from intersystems cache?

I have seen the document of inter-systems cache describes calling other programming functions like c,Java. could any one help me to understand the way of doing it with simple Java example.
Krishnamuthu
  • 61
  • 6
0
votes
1 answer

cache in macosx

I installed cache in macos x. But i cant able to open a studio there and i cant able to see cache cube there.How do i will open it and create clasess,routines,...etc in cache in mac osx.
user171843
0
votes
2 answers

Excel through Access through ODBC Cache DB - locking licenses issue

I have an excel workbook set up with 25 sheets in it. Each sheet has a data connection to a query in MS Access. Each access query has one or more linked tables from an InterSystems Caché DB. Here is the connection string from one of…
45Spartacus
  • 1
  • 1
0
votes
1 answer

How to connect Intersystems cache web services and PHP?

I want to connect Intersystems cache web services with php. I dont know how to use soap headers for this work. Using soap session only, i can set csp session in CSP. Can anyone help me to set soap headers for this process? or else explain how to…
ragu
  • 165
  • 3
  • 6
  • 15
0
votes
4 answers

split string in sql query

I have a value in field called "postingdate" as string in 2009-11-25, 12:42AM IST format, in a table named "Post". I need the query to fetch the details based on date range. I tried the following query, but it throws an error. Please guide me to…
Mani
  • 1
  • 1
0
votes
1 answer

What is the fastest way (at run time) to have an Intersystems Cache database stored procedure return nothing but a BLOB?

This question is specifically about Intersystems-Cache databases. I'm currently using $$$ResultSet("MySQLQueryText") to select the BLOB from a table, but this is probably writing the BLOB to the table, then reading out from the table, instead of…
psr
  • 2,870
  • 18
  • 22
0
votes
1 answer

How to put sql inside sql

select idRuler AS CURRID, beginDate, endDate, (SELECT SUM(TotalYearsAtService) FROM Ruler WHERE idRuler=CURRID ) AS PeriodTotal, (SELECT COUNT(DISTINCT IDstateddFK)), nameRuler AS Name FROM Ruler, Position,…
Tigran
  • 1,049
  • 3
  • 15
  • 31
0
votes
2 answers

How to write output to a file on a Unix server using Intersystems Caché?

I'm trying to execute a query in Caché and output the results to a file on a Unix server, but I'm having trouble finding the right commands. I tried the following: %SYS>s rs=##Class(%ResultSet).%New() %SYS>s rs.ClassName="%SYS.Namespace" %SYS>s…
user2063351
  • 503
  • 2
  • 13
  • 31
0
votes
1 answer

Print/Read a line cache objects

I would like to read a line in cache class. I can read a line in cache routine using ZLOAD and PRINT. But I am not able to acheive the same in cache class. Please Help me on this.
user3012936
  • 1
0
votes
2 answers

How to create a ClassMethod in InterSystems Cache that returns a %SQLQuery?

Here's a Query Method: Query getSample() As %SQLQuery [ SqlProc ] { SELECT * FROM TEST.xSample } The getSample Query will be called by a method in VB and it would be assigned to a DataTable typed object. How can a ClassMethod that would return…
Diaton
  • 151
  • 7
0
votes
2 answers

Return just the results from %SYS.ProcessQuery using $SYSTEM.SQL.Shell() in Intersystems Caché on a Unix server

Background Hi, I work with a Unix-based application that uses an Intersystems Caché database. Since I'm not that familiar with Caché, it wasn't until recently that I found out I could type... $ cache ...to enter the database. From here, I found out…
user2063351
  • 503
  • 2
  • 13
  • 31
0
votes
0 answers

REST Node.js and express Evented I/O for V8 javascript has stopped working

I tried creating a new database object in each call and I still get the same error. (because of variable scope shouldn’t they be different objects in each call?) Here is the function called. exports.get_type = function(req, res ) { var…
Geronimo Gando
  • 1
  • 1
0
votes
1 answer

InterSystems cache - how to insert into a join table?

The following objectscript will create the following SQL table: Objectscript Class Class MyApp.Parent Extends %Persistent { Property Children As array Of MyApp.Child; } Parent_Children table and columns: Parent int NOT NULL, ID varchar(254) NOT…
O.O
  • 11,077
  • 18
  • 94
  • 182
1 2 3
…
26 27