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

CacheSQL calculate total time

I'm looking to calculate the total time from a column similar to this forum: https://stackoverflow.com/questions/3054943/calculate-sum-time-with-mysql Here is my code that is not working: SEC_TO_TIME(SUM(TIME_TO_SEC(CASE WHEN (SUBSTR(Total_Time,1,2)…
eatonphil
  • 13,115
  • 27
  • 76
  • 133
0
votes
1 answer

SQL - CASE WHEN Error?

Could somebody help me out? I'm not sure why this code keeps not executing: '0' || CASE WHEN (EAmain.ActivityStopMin - EAmain.ActivityStartMin) < 0 THEN (DATEDIFF(hh,EAmain.ActivityStartTimeHours || ':' || …
eatonphil
  • 13,115
  • 27
  • 76
  • 133
0
votes
1 answer

Caché SQL - Convert Minute format to Hours

I am working with a table that already exists that has columns formatted in some sort of a minute format. It looks like it was meant to be hh:mm, but it is not quite. For instance, where it should be 03:00, it says 01:80 for 180 minutes. Or for 1:30…
eatonphil
  • 13,115
  • 27
  • 76
  • 133
0
votes
1 answer

CacheSQL datediff format hhmm

I need to calculate the variance in minutes or hours from two columns. Using datediff(hh,start,stop) is sometimes to big and datediff(mi,start,stop) is sometimes to little. How can I get it show up as hh:mm? Thanks!
eatonphil
  • 13,115
  • 27
  • 76
  • 133
0
votes
4 answers

Convert four Digit number into hour format SQL

I have looked into Cast and Convert, but I cannot find a way to do this. I need to convert four digits into an hour format. For instance, 0800 would become 8:00 or 1530 would become 15:30. I cannot use functions, I'm using a InterSystem's CacheSQL.…
eatonphil
  • 13,115
  • 27
  • 76
  • 133
0
votes
2 answers

Unit testing frameworks for Intersystems Caché

Are there any unit testing frameworks for Intersystems Caché? If so, please list some.
O.O
  • 11,077
  • 18
  • 94
  • 182
0
votes
2 answers

Changing RowIds when saving cache object that uses cache sql storage

First I apologise for the lengh of this question.. I have a global set up in the following…
Fred Altman
  • 221
  • 1
  • 2
  • 5
0
votes
1 answer

How do include a global's extended reference when creating a class using cache sql storage?

I am creating a class that is mapped to an existing global so it uses cache sql storage not default storage. This class has extended references (UCKE, SYKE) whose values are set at run-time. How do I include the extended reference in the sql…
Fred Altman
  • 221
  • 1
  • 2
  • 5
0
votes
1 answer

Wait integrity test to finish (Do Silent^Integrity("/tmp/logfile"))

I would like to know how it's possible to run a integrity test without starting it in background. So I want to run it in foreground and wait until it's finished. The following runs on background…
user74952
  • 35
  • 2
  • 5
0
votes
2 answers

Can you perform code indirection in .NET?

I remember with InterSystems Cache code, you can use indirection to take a string and turn that into real executable code by preceding the string variable with "@". Can this be done in C#.NET or VB.NET code? So I'd like to have a method that would…
JustBeingHelpful
  • 18,332
  • 38
  • 160
  • 245
-1
votes
3 answers

SQL Excluding data based on certain criteria for a date range

How to exclude records with certain values in sql select I need to exclude the entire month where Video or Face-to-Face exist but keep the months where either one of those options is not found. I'm using the NOT EXISTS which works but when I filter…
Tony Pham
  • 1
  • 2
-1
votes
1 answer

Nesting a CAST() Function

I am attempting create a nested CAST() function and am struggling with the syntax. My simplified code so far: SELECT discharge_date, admission_date, Patient_Uniue_ID, CAST(CAST(Year(admission_date) AS VarChar(4)) + '-' + CAST(Month(admission_date)…
mkelsh
  • 1
  • 1
-1
votes
1 answer

# in Caché between columns

I have a SQL query and I would like to insert a hashtag between one column and another to be able to reference in Excel, using an import option in fields delimited by #. Anyone have an idea how to do it? A query is as follows: SELECT FC.folha, …
Rogér
  • 5
  • 2
-1
votes
2 answers

Cannot convert from 'method group' to 'string'

hi guys i got problem on both of my userID.GetUserByID and getIP.GetIPAddress it tells me that i Cannot convert from 'method group' to 'string' but if i don't add even one of them i don't get an error but i add either one of the that error pops…
Reden Rodriguez
  • 35
  • 1
  • 7
-1
votes
2 answers

Connecting to an Intersystems Cache DB through Oracle SQL Developer

I was wondering if it was possible to use the Intersystems ODBC Driver to connect to an Intersystems Cache DB through Oracle SQL Developer? If yes, then how?
Apollo Culligan
  • 1
1 2 3
…
26
27