Stack Overflow
Stack Overflow

Questions tagged [intersystems]

InterSystems is a software company based in Cambridge, MA.

They sell many products related to software development, application integration and data storage including IRIS Data Platform, Caché, Ensemble, and HealthShare.

The products are based on the database (supports SQL, Object, NoSQL access) and the programming language.

Resources

Related tags

130 questions
4
votes
3 answers

Continuous Integration for Intersystems Cache solutions

I am starting a project from scratch using Intersystems Cache. I would like to setup a Continuous Integration Server for the project. Cache has unit test libraries, so the idea is to import source into a test database, build the source, run unit…
Raymond Roestenburg
  • 4,890
  • 2
  • 20
  • 18
4
votes
1 answer

Base64 encoding and decoding using Caché Object Script

Is there any "built-in" methods or ways to encode/decode to/from BASE64 string in Caché?
ZitRo
  • 1,163
  • 15
  • 24
4
votes
1 answer

Caché Object Script Code guidelines

I work with InterSystems Cache and look for Caché Object Script coding guidelines. Does someone have any example?
Evgeny Shvarov
  • 468
  • 5
  • 17
4
votes
3 answers

Compare strings in Intersystems Cache Objectscript

Given: 2 strings strA, strB I want: To perform a comparison between them and return <0, =0 or >0, in Intersystems Cache ObjectScript. So far: I have found a function in the documentation that fulfills my needs StrComp. Unfortunately, this function…
matmat
  • 85
  • 9
4
votes
1 answer

Redirect current IO device for 3rd party routine interaction

I have many vendor supplied M-Code routines as part of a much larger product that use READ and WRITE directly to interact with the current device. I can't change that code. I want to wrap some of those routines in a system where I can supply input…
Chris Smith
  • 5,326
  • 29
  • 29
3
votes
2 answers

InterSystems Cache, where to find global definitions

Using only the Cache terminal, what utility function, or Global do I use or look in to find a list of all the Globals which exist in a Cache database? Again usin only the Cache terminal, what utility function or Global do I use or look in to find…
Intrinsic
  • 59
  • 4
3
votes
2 answers

Unexpected result from COUNT query

I am experiencing a weird problem while getting count from one table. The table name is Client and there is a varchar(200) column named CardNo. The database engine is Intersystems Cache and the querying syntax is SQL. I execute queries below to get…
Ahmet
  • 85
  • 1
  • 8
3
votes
2 answers

Difference between two date time stamp in Intersystems Cache

I would like to find out the number of hours and minutes between two date time stamp. if for example sDateTime = 2016-01-01 01:00 eDateTime = 2016-01-03 02:30 I would like it to output it as 49:30 (49hours and 30minutes) I am unable to figure…
jk1844
  • 327
  • 1
  • 5
  • 12
3
votes
1 answer

Anyone use SonarCube with ObjectScript

We use InterSystems Cache which has a development language called ObjectScript (kinda looks like VB). It has it's own IDE called Studio. Has anyone been able to successfully use SonarQube with Studio/ObjectScript? There is no plugin for it. Thanks…
IamSpartan87
  • 31
  • 2
3
votes
1 answer

JSON data against DeepSee MDX queries in InterSystems Caché

I want to retrieve JSON data against MDX queries on DeepSee OLAP cubes in InterSystems Caché. Any ideas?
Evgeny Shvarov
  • 468
  • 5
  • 17
3
votes
2 answers

What's the best practice to work with ENUM in Intersystems Caché?

Natively, Caché doesn't implement ENUMs such as Java for example, when you need to implement a solution like the following example in Java, but in Caché, what are the best practices? public enum Planet { MERCURY (3.303e+23, 2.4397e6), VENUS …
Lucas Boeing Scarduelli
  • 147
  • 8
3
votes
2 answers

How to check a column exists in a table in Intersystems Cache SQL?

I've noticed that while I can use %dictionary.compiledclass to get a table with schema names and table names, which allow querying for their existence, I cannot do the same for columns. I have yet to find the command that allows verifying whether a…
Ahab Lollington
  • 31
  • 4
3
votes
6 answers

InterSystems Caché - How to get access to Caché Studio?

I am a Caché admin so I have have all access to the system managment portal. I would like to use Caché studio but my login doesn't seem to be setup properly for that. I am new to Caché, only been using it for 2 months now, I am learning the Jargon.…
JIM GAUL
  • 31
  • 1
  • 3
3
votes
1 answer

How to create a unique GUID in intersystem's cache?

Looking through the documentation I don't see a GUID datatype. Is there a function or something to generate a random GUID? What is it?
O.O
  • 11,077
  • 18
  • 94
  • 182
2
votes
3 answers

Type checking on Caché Objects

What is the point of type definition on method parameters on Caché Object (from Intersystems) since after it's pre-compiled to the .int format, it removes any typing information, thus making no difference at all?
Francisco Fiuza
  • 421
  • 1
  • 5
  • 4
1
2 3
…
8 9