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

intersystems - Cache Database - DB model

I have a requirement to read data from Cache database, before that i would like to see the DB model(List of tables or classes etc).I have used Management tool but i could'nt find out the tables list.How we find out the DB model using management…
vks
  • 6,649
  • 7
  • 36
  • 55
1
vote
1 answer

Read entire file bytes at once using intersystems' Cache?

I have a file of bytes 1.5GB in size {filebyte}. I want to read the entire file in one instance instance similar to Delphi's bytedata:=filebyte.readallbytes(filename); The result being that in one instance you will have a bytearray with the number…
Jimmy Dean
  • 153
  • 2
  • 7
1
vote
2 answers

How do we examine a particular job in GTM?

Just as we have in Intersystem Cache D ^JOBEXAM to examine the jobs running in background or scheduled. How can we do the same in GTM? Do we have any command for the same. Please advice.
Dhaval Shah
  • 9,042
  • 2
  • 14
  • 21
1
vote
2 answers

MUMPS $Functions in SQL Statements

Can $Functions like $Extract, $P be used in SQL statements? If they can, please provide and example. Ex Select $P(Field1,"*") from MyTable. This returns an error saying "A term expected beginning with either..."
user6284097
  • 157
  • 1
  • 1
  • 9
1
vote
1 answer

How to change a GLOBAL Node's value with VisM?

I have access with VisM via VB.net, and can query GLOBAL nodes with it. However, let's say I have a node that looks like this, ^KOT("CNTR","KOT") = 38499 how can I chage the value 38499 to something else? like an update?
Malcolm Salvador
  • 1,476
  • 2
  • 21
  • 40
1
vote
1 answer

Output a list of GLOBALS or a single GLOBAL value with VisM

I have dded a VisM control into vb.net via adding a reference to VisM.ocx and adding it in my toolbox as an activeX control. I added the following code in a button: Try 'open the connection AxVisM1.Connect("CN_IPTCP:127.0.0.1[1972]") …
Malcolm Salvador
  • 1,476
  • 2
  • 21
  • 40
1
vote
1 answer

Intersystems CACHESQL Database Globals to ODBC or cacheSQL client

I have a Intersystems CacheSQL Database which I have to work with in .net (VB or C#). The problem though, is that most data are not stored in Intersystem's CacheSQL, but rather in it's GLOBALS storage (which I think are arrays). A GLOBALS array…
Malcolm Salvador
  • 1,476
  • 2
  • 21
  • 40
1
vote
2 answers

Custom drilldown

Good evening. Please tell me how to write a custom drilldown. There are city (City), every city has the number of births (Amount) for each day (for example: in the last month), the values ​​of today there is empty Here is an example of MDX query to…
TsvetkovAV
  • 13
  • 3
1
vote
2 answers

Set a datatype java.util.Date property of proxy Java Object in Cache by Gateway Java

I'm implementing a solution that integrates a Caché application with a Java application by a Java Gateway. In the Java application I have a object what have a property of datatype "java.util.Date" and I have to set this in the Caché application.…
Lucas Boeing Scarduelli
  • 147
  • 8
1
vote
1 answer

Intersystems Caché SQL. Different behaviour trailing withespaces vs leading withespaces

Given: A table tA with an "ID" and a "Description" columns "Description" is a string column. The contents of the table are: ID || Description 1 || "String1" 2 || "String2" 3 || "String3" If I execute the following SQL…
matmat
  • 85
  • 9
1
vote
1 answer

InterSystems Caché ODBC - max result length

I use ODBC for querying on InterSystems Caché db. In C# I do: DbCommand.CommandText = "select Class_getTablesMetaXml('globalName') As returnStr"; OdbcDataReader reader = DbCommand.ExecuteReader(); Everything is OK, but if returnStr is longer than…
mrfazolka
  • 780
  • 1
  • 7
  • 24
1
vote
1 answer

How to Create a user in Security.Users using Cache Class?

I am new to Intersystems Cache. I am trying to create a user via cache class i.e., through.cls file. Is it possible? Note: From documentation I found that create(username,.....) API available. Please suggest some fruitful solutions.
Sivam
  • 1,099
  • 3
  • 12
  • 25
1
vote
1 answer

Issues while connecting to the intersystems cache from Java

I am trying to write an example to connect to the Intersystems Cache from a Java class. I am using the eXtreme Data Objects framework from Intersystems Cache`. Here is the source code - package demo; import…
user3600073
  • 1,773
  • 3
  • 18
  • 21
1
vote
1 answer

File Listener in Ensemble/CachObjectscript

I am new to ensemble. I would like to know, whether there is any thing like filesystemwatcher in Cache/Ensemble. (Note : filesystemwatcher is in .Net) My requirement is as follows, My Ensemble production (Business Process) will drop a file in a…
arun.v1
  • 462
  • 1
  • 4
  • 12
1
vote
1 answer

How to pass DBNull.Value to DB using CacheParameter

var dbParameter = command.CreateParameter(); dbParameter.Name = "myParam"; dbParameter.Value = DBNull.Value; command.Parameters.Add(dbParameter); sql is like this: select * from Person where Name is ? Get an error: An exception of type…
O.O
  • 11,077
  • 18
  • 94
  • 182
1 2 3
…
8 9