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

get current url with "csp intersystem cache objescript"

as I can get the current url with csp cache language ? without using mv. I also want to get the current domain ie if I have this url www.midominio.hn / assets / hola.csp get www.midominio.hn
Ronal Vasquez
  • 109
  • 2
  • 14
0
votes
1 answer

Can't update specific columns? Only large string columns?

I'm trying to run some simple update statements on Cache 2008. Loging into the web portal. I'm able to run queries like: update testspace.clients set requires_attention = 'Yes' , notes = 'testsdfsd' where id = '1||CPL62549.001' The web portal runs…
AaronS
  • 425
  • 1
  • 5
  • 10
0
votes
2 answers

How should I do my own version of a %Library.RelationshipObject collection, without subclassing it?

I'm trying to have a collection class similar to %Library.RelationshipObject in that it manages saving and deleting the objects in the collection. I'd like the flexibility to do this with my own objects, so I don't want to use the relationship…
psr
  • 2,870
  • 18
  • 22
0
votes
2 answers

How to run a SQL script in Intersystems Cache?

I have a script in a file (mysqlscript.sql) that is basically a bunch of inserts/updates/deletes separated by GO statements insert into .... GO update ..... GO How do I run this script?
O.O
  • 11,077
  • 18
  • 94
  • 182
0
votes
1 answer

Intersystems cache: project %ID in resultset using web services

I have a cache object class with 3 properties: name dob address When I return it as a resultset using a web service I get the 3 properties, as expected. How do I also get the %ID in the XML projection, since the object is also persisted?
0
votes
1 answer

Global mapping of one subscript dimension to another database

I have a vendor defined database (about 140GB total) on Caché 2007. It uses the old style MUMPS programming environment and accesses globals directly in a hierarchical style. There is one global that accounts for about 75% of the total database…
Chris Smith
  • 5,326
  • 29
  • 29
0
votes
3 answers

How can I perform some commands on Intersystem cache from shellscript?

I want to perform some commands on Intersystem cache from shell script. One solution which I know is through making a config file but the problem is I dont know how to use config file through shell script. Is there any other solution for this... for…
Ajit Nair
  • 435
  • 2
  • 10
  • 19
0
votes
1 answer

How to stop CACHE instance from Shell Script

I want to restart CACHE(database that I am using) Instance from shell script. What I did is created a function in the shell script named restart_cache. restart_cache() { ccontrol stop instancename restart } This command is running but the control…
Ajit Nair
  • 435
  • 2
  • 10
  • 19
0
votes
1 answer

WCF Duplex communication with InterSystems

Can someone point me to a sample of how to call a WCF service using wsDualHttpBinding? I created the classes using the SOAP Client Wizard and everything compiles. When I run the objectscript code, it hangs on the web service call for a while (it's…
O.O
  • 11,077
  • 18
  • 94
  • 182
0
votes
3 answers

Inherited Relationship not working as expected

I have the following classes: Class SearchTemplateDO [ Abstract ] { Relationship QueryParts As QueryPartDO [ Cardinality = many, Inverse = SearchTemplate ]; } Class MyCustomSearchDO Extends (%Persistent, SearchTemplateDO) { /// inherits all…
O.O
  • 11,077
  • 18
  • 94
  • 182
0
votes
1 answer

%XML.DataSet creating invalid xml

Class Services.TestClass Extends (%RegisteredObject, %XML.Adaptor) { Property DS As %XML.DataSet; } and the following web method inside my web service class: Method HelloWorld(name As %String) As Services.TestClass [ WebMethod ] { Quit…
O.O
  • 11,077
  • 18
  • 94
  • 182
0
votes
1 answer

How to add node to Cache Web Service WSDL?

Need to add ... like this I set the INCLUDEDOCUMENTATION parameter to 1, but that doesn't generate it.
O.O
  • 11,077
  • 18
  • 94
  • 182
0
votes
3 answers

How to test if an array of objects contains a string?

In C# I can do this: public string[] MyStrings; ... ... if(MyStrings.Contains("bob")) ... In ObjectScript how is this done? With %ArrayOfObjects type I don't see exactly what I am looking for here What I have tried: #Dim MyStrings As…
O.O
  • 11,077
  • 18
  • 94
  • 182
0
votes
0 answers

How to import a class and keep the same package directory structure?

I created a bunch of classes and packages in the USER namespace for prototyping. Now I need to move all of these classes into a different namespace. When I export/import the classes from the USER namespace to another namespace, the package…
O.O
  • 11,077
  • 18
  • 94
  • 182
0
votes
1 answer

Edit column when selected based on content

I need to find a way to search all columns along these lines: select CASE When substr(column,1,7) = 'Report:' then substr(column,8) when substr(column,1,5) = 'Print' then substr(column, 6) else column end …
eatonphil
  • 13,115
  • 27
  • 76
  • 133