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

Oldest Record discrepancy?

I was trying to determine the oldest record in a table and am having conflicting results. Scenario 1 SELECT TOP 10 * FROM Ens_Util.Log ORDER BY TimeLogged ASC SELECT TOP 10 text, TimeLogged, TraceCat, Type FROM Ens_Util.Log ORDER BY TimeLogged…
user736893
2
votes
2 answers

Intersystems Cache script character limit

what's the character limit (number of characters) which send command has and how can I change it? If I run a long command , it's not getting send completely and an "S" is appended to the end of the string (and string is cut off) so is there a way to…
Mahyar
  • 1,011
  • 2
  • 17
  • 37
2
votes
2 answers

Retrieving seconds since last record

I thought this would be simple, but I have a problem. SELECT DATEDIFF (s,getdate(), max(TimeCreated)) as difference FROM Ens.MessageHeader My expectation was that this would show the difference between the current time and the timestamp of the most…
user736893
2
votes
1 answer

String can't be split by Tab or Space. Which character is this?

I have this string which looks like this: 613 3503||0 82 1 49 1 1950 63543 11301 3 CORP-A1 1656.06 150 0 N 82.8 198.72 12.42 N 0 0 0 N Y 1 However, when I string split it by either TAB or SPACE, it does not split via Tab or space. It still outputs…
Malcolm Salvador
  • 1,476
  • 2
  • 21
  • 40
2
votes
2 answers

How to programmatically import an XML export file into a Caché installation?

The situation is as follows: I have an XML export of a project; I have a working Caché installation (which means I have cachedb.jar and cachejdbc.jar); I have a namespace/user/pass to work with. What I want to do is: import the XML into this…
fge
  • 119,121
  • 33
  • 254
  • 329
2
votes
2 answers

How to get DB resource knowing DB name?

I have database name. I need to get db resource. How? One option I see is to execute Config.Databases:List query and iterate over results till I find required name. After that open db by path and get the resource.
rfg
  • 1,331
  • 1
  • 8
  • 24
2
votes
1 answer

Updating a form generated by a wizard based on a class

I'm following the tutorial here. I created my data class and added a name property using the wizard. I then created a zen form using the wizard, during which I selected the data class created above. Everything worked great. However, I went back…
user736893
2
votes
1 answer

What is the best practice to read full POST request body when using REST in Caché?

Having the following UrlMap: What is the best (easiest?) way to read full request body, without string length limitations ($$$MaxStringLength) or anything that may cut…
ZitRo
  • 1,163
  • 15
  • 24
2
votes
1 answer

How to check if %ZEN.proxyObject has a property in Caché Object Script?

How to properly check that some %ZEN.proxyObject's object has a specific property? In my case I have %ZEN.proxyObject instance. My guess is set p = $PROPERTY(object, "propertyName"). $PROPERTY returns an empty string if property does not exists, but…
ZitRo
  • 1,163
  • 15
  • 24
2
votes
1 answer

Terminal emulation for InterSystems Cache in browser

Sometimes I need to run terminal driven system utilities for InterSystems Caché database but have no ssh access. On the other hand I have web access to this server. Are there any solutions of terminal emulation in browser?
Evgeny Shvarov
  • 468
  • 5
  • 17
2
votes
2 answers

How can I print from DeepSee Dashboards?

Intersystems DeepSee provides a version of Apache FOP for pdf render. I'm facing "java probably not in path" in csp error page. I've tried to set JAVA_HOME at "../@jdkinstallpath@", "../@jdkinstallpath@/bin" with the same result. Cache 2014.2. Any…
Vladimir Kolodyazhnyy
  • 21
  • 2
2
votes
2 answers

How to backup a set of tables periodically in cache instead of an entire namespace?

Is there a way in which i could back just a set of tables in cache? I've looked at the System management portal and it seems all you could do are are the following. Configure Full Backup of All Databases Configure Full Backup of the Database…
JasG
  • 21
  • 1
2
votes
2 answers

Intersystems caché - programmatically create new class

Is it possible to write ObjectScript method, which will create new class in namespace and compile it? I mean programmatically create new class and store it. If so, can I edit this class using ObjectScript later(and recompile)? Reason: I have class…
mrfazolka
  • 780
  • 1
  • 7
  • 24
2
votes
1 answer

How to use object script in a SQL Proc for an Intersystems Cache database

Intersystems Cache provides interfaces to run SQL relational queries against a cache database. When trying to do aggregate queries across the object data structures is very slow and sometimes practically impossible. Is there a way to have an object…
carl
  • 33
  • 5
2
votes
2 answers

How to get data from intersystems cache db through ODBC?

This is how i try to get a data from db: #include #include #include #include "iostream" int main(int argc, char *argv[]) { QSqlDatabase db = QSqlDatabase::addDatabase("QODBC"); …
Daynin
  • 41
  • 5
1 2 3
…
26 27