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
1
vote
4 answers

Query in SQL Server Management Studio fails to pass date to linked InterSystems server

I have a SQL Server and Cache server and need to combine some data. Most all functions are working, except when I attempt to pass a date with a variable or a parameter. Below is a test I ran (one of many). declare @myDate datetime set @myDate =…
user1193540
  • 11
  • 1
  • 3
1
vote
3 answers

How do I reference a local method's name property in code?

I have a cache object property that I'd like to set to the current class and method in context's name, in order to do some tracking on what methods/classes are generating the largest frequency of these objects. I can easily grab the current class'…
mccrackend
  • 137
  • 8
1
vote
0 answers

Set network interface on client host to be used for Cache connections

I'm connecting to Intersystems Cache database using Intersystems JDBC Driver. There are several network interfaces on client host. I need to make all the Cache traffic to go through a particular interface. Is there a way to choose which network…
sys463
  • 337
  • 2
  • 5
  • 18
1
vote
1 answer

Can SQL queries across namespaces be made?

Is it possible to make a query across tables in different namespaces? Eg: select A.TS as A_TS, B.TS as B_TS from ns1.schema.table as A left join ns2.schema.table as B on A.id = B.id At least, is it possible to get tables A and B using the same…
dmcontador
  • 660
  • 1
  • 8
  • 18
1
vote
1 answer

facing the error “command 'vscode-objectscript.explorer.refresh' not found” in Visual Studio Code (Version 1.49.0) with IRIS 2020.1.0.215.0

I'm facing the error “command 'vscode-objectscript.explorer.refresh' not found” in Visual Studio Code (Version 1.49.0) with IRIS 2020.1.0.215.0. My settings are the following : { "objectscript.conn": { "active": true, "host": "localhost", "port":…
Sylvain
  • 66
  • 6
1
vote
1 answer

Intersystems IRIS Data Platform cant change default password

I am currently testing the docker container for the InterSystems IRIS Data Platform. I want to change the default password with this line (from dockerhub instruction:…
Celebrombore
  • 170
  • 11
1
vote
1 answer

ODBC Column Length Limitations

I am working with InterSystems Cache database via ODBC and PHP. I have run into an issue regarding column name lengths and invalid characters being returned in the column name text. If the length of a column(field) name exceeds 31 chars the column…
Michael Mazza
  • 11
  • 4
1
vote
1 answer

How does Intersystems cache recall the covered code

I drag my .cls file to Intersystems studio, the old version code covered my latest version code, is there any way to get back my covered cls file ?
DylanLeeee
  • 31
  • 1
1
vote
1 answer

Could intersystems cache global nodes be ordered by the second node?

I want to sort the string(or number) by the second global nodes(the $o is ordered by the first node then second node ...but i don't care about the first node, i just want the data sorted by the second node, just ignore the first node). as if i want…
DylanLeeee
  • 31
  • 1
1
vote
2 answers

Does intersystems cache have a wildcard to search global node?

Sometimes i want to search a character with wildcard, I don't want to search all the global nodes to find specific characters. so i want to know is any wildcard i can use to match specific characters on global nodes. as if i want to find ^G("abc")…
DylanLeeee
  • 31
  • 1
1
vote
1 answer

Update value of other column on update of this column

i have question, how to do something like a trigger in Intersystems Cache. Situation: for example i have table X with properties(columns) valueA,valueB i Want to update valueB when valueA changed by UPDATE. I have define global variable ^VALUEBGENER…
Dmitriy Sosnovich
  • 21
  • 7
1
vote
3 answers

Access instance variables in Cache Objectscript

I have a routine where I dynamically instantiate persistent objects using reflection. One of the properties of the object, which is also a persistent object, fails when I try to instantiate it using reflection ($Property). It fails because the…
wipallen
  • 144
  • 2
  • 11
1
vote
3 answers

Sending An HTTP Request using Intersystems Cache

I have the following Business Process defined within a Production on an Intersystems Cache Installation /// Makes a call to Merlin based on the message sent to it from the pre-processor Class sgh.Process.MerlinProcessor Extends…
Paul S Chapman
  • 832
  • 10
  • 37
1
vote
1 answer

MUMPS to Cache database migration

A client wants information extracted from their MUMPS database and transferred to a cache database, where do I begin and what are some best practices I should keep in mind? (I am fairly new to MUMPS and have been put on this project)
orxcle
  • 11
  • 1
1
vote
1 answer

Does object script supports multiple inheritance?

I am new to cache and found something different from normal oop concept. In object script a base class can be inherited from multiple subclasses(inheritance order can be left/right). If objectscript is oop, I don't know how cache supports…
Vivek Ranjan
  • 1,432
  • 2
  • 15
  • 37
1 2
3
…
8 9