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

Intersystems Caché custom storage of persistent object

I have data in global in this format: ^kza("mltab","TAB","Dta",1,1) = 3341 ^kza("mltab","TAB","Dta",1,2) = "First Name" ^kza("mltab","TAB","Dta",1,3) = "type1" ^kza("mltab","TAB","Dta",1,4) = 7400.11 ^kza("mltab","TAB","Dta",2,1) =…
mrfazolka
  • 780
  • 1
  • 7
  • 24
0
votes
2 answers

Date Parameter to Cache SQL

I am very new to Cache. I am trying to develop a report with date parameters. When I issue the SQL command: SELECT TOP 2 ad.admission_date from system.admission ad WHERE convert(sql_date,ad.admission_date) >= convert(sql_date,'08-01-2014' ) I get…
Andrew Wheeler
  • 1
  • 2
0
votes
1 answer

How to add auto increment(IDENTITY) to existing column in intersystems cache database

In intersystems cache, I have an existing table with example data as below ID Name 1 Allen 2 Benny I want to modify column ID so that it will be auto incremented. After adding this, if I insert charlie into the table then the id should be 3. I…
Raja
  • 429
  • 4
  • 16
0
votes
1 answer

SQL query if select criteria is null output to be text

I'm trying to add to an existing SQL query to output "No Data Found" if the entire query is null. I want to display "No data Found" instead of showing a blank output. Database I'm writing the SQL query is towards InterSystems Cache. Any help is…
Dagz200
  • 221
  • 7
  • 15
  • 25
0
votes
1 answer

Number of login sessions for a time period in Intersystems Cache database

This question is related to Intersystems Cache Database. I want to know all the new users that got created for a particular time period. Also, Is there a way to figure out number of logins for a given time period?
Raja
  • 429
  • 4
  • 16
0
votes
2 answers

lcbjni in Intersystems Cache

We have Intersystems Cache 2010.2.3.702.0.10761 installed on AIX. When I run an eXtreme - Globals API program I am seeing LCBJNI related errors. Does the Cache 2010.2.3.702.0.10761 have lcbjni? If so, where can I find. Please help
user3600073
  • 1,773
  • 3
  • 18
  • 21
0
votes
1 answer

Intersystems Cache using XEP

I am trying to extract data from the Samples namespace that comes with Intersystems Cache install. Specifically, I am trying to retrieve Sample.Company global data using XEP. Inorder to achieve this, I created Sample.Company class like this…
user3600073
  • 1,773
  • 3
  • 18
  • 21
0
votes
1 answer

Mule Database connector issue

I have a stored procedure in Cache Database, and I am trying to call it from Mule database connector. I am able to connect to it, but every time, when I call the procedure, it is giving the following error on console, java.sql.SQLException:…
Vicky
  • 871
  • 9
  • 16
0
votes
1 answer

Getting Cache connection error: "Cache Security Error"

I am trying to connect to a Cache database. I can connect to to the database in question with a predefined ODBC DSN connection with my username and password. What I want to do is use a SQL connector, Intersystems.Data.CacheClient.dll to connect. I…
Liquid-Ice
  • 11
  • 3
0
votes
2 answers

Intersystems Cache coding query

SELECT Distinct visitid As Visit_ID, AreaId->FacilityID As Facility_ID, visitid-PatientSecondaryNumber As Patient_MRN, visitid->PatientName As Patient_Name, visitid-statustext As visit_Status, …
FatherofFaris
  • 41
  • 1
  • 5
0
votes
1 answer

Intersystems Cache: Querying a table that has a column with data type of another table

What is the notation I need to use to extract specific/all row and field information from a field that is of type table (basically an embedded table inside of a field)?
kftaba
  • 1
0
votes
1 answer

restarting Intersystem Cache for lockout time

Hi is it possible to restart the database from the management portal. I'm trying to increase the lockout time do I need to restart the database.
FatherofFaris
  • 41
  • 1
  • 5
0
votes
2 answers

In Caché ObjectScript, what is the `Aliases' property keyword

Under Intersystems Property Keywords documentation Aliases is not listed as a keyword. However, in studio if I type Property Tst As %String [ the drop-down pops up with Aliases and fills it with Property Tst As %String [ Aliases = The only way I…
jtzero
  • 2,204
  • 2
  • 25
  • 44
0
votes
2 answers

Ensemble runtime global lock

When I try to start up my Ensemble production, I get the following error: ERROR ErrCanNotAcquireRuntimeLock: Could not acquire Ensemble runtime global lock within timeout '10' I figured I will disable all the services, processes and opperations…
NotMyName
  • 682
  • 2
  • 7
  • 15
0
votes
1 answer

Can i able to make Trigger in Cache for mapped global?

I need to create a trigger function that would be called whenever i insert or delete data to my table. Internally cache keeps the data in a global. in the reverse way i can add data directly to the Global and i can view it in the table. The trigger…
Krishnamuthu
  • 61
  • 6
1 2 3
…
26 27