Caché

Syndicate content 122 

Description

  

InterSystems Caché is a multi-model DBMS and application server

See more details here.

Documentation.

Download Caché Evaluation

Most votesMost viewedArticlesAnnouncementsQuestionsNo answerNo accepted answerAll

NewBie's Corner Session 3 More Read and Write commands & Multiple commands

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

Click on the Caché Cube in your system tray and select Terminal to try out the commands.

Write command with carriage return and line feed

When the exclamation point "!" is inserted after a Write command, a carriage return and line feed combination is produced. Note in this example, that a comma separates the exclamation point from the variable "X".

Continue Reading
Mike Kadow's picture
Post by Mike Kadow 17 May 2016
Last comment 14 July 2016
0   0 2
1

comments
231

views

0

rating

The Caché System Management Portal includes a robust web-based SQL query tool, but for some applications it’s more convenient to use a dedicated SQL client installed on a user’s PC.

SQuirreL SQL is a well known open source SQL client built in Java, which uses JDBC to connect to a DBMS. As such, we can configure SQuirreL to connect to Caché using the Caché JDBC driver.

Continue Reading
Marc Mundt's picture
Post by Marc Mundt 30 June 2016
Last comment 13 July 2016
+ 7   0 9
8

comments
2788

views

+ 7

rating

We can override soap body by using WriteSOAPBodyMethod. Something like:

Method Online(ByRef Obj1 As myClass1, Obj2 As myClass2, Output ObjOutput1 As myClass1Output(XMLNAME="Obj")) [ ..., WebMethod ]

{

              …

              s ..WriteSOAPBodyMethod="override"

              d (..WebMethod("Online","ProcessRequest")).Invoke($this,"Online",.Obj1,.Obj2,. ObjOutput1)

              s ..WriteSOAPBodyMethod=""

              …

}

Method override(proxy As %SOAP.ProxyDescriptor, tag As %String)

{

              …

}

Continue Reading
Ricardo Paiva's picture
Post by Ricardo Paiva 13 July 2016
Last answer 13 July 2016
0   0 1
1

answers
0

comments

172

views

0

rating

Hello,

One of our AP would like us to provide the file upload/download sample code by using ZEN Mojo.

I already provided them the attached "upload-sample".

I tried to create the "download-sample" in a similar way, but I couldn't do it yet.

Does anyone have a good idea/sample about this?

I'd like to download the server side file(e.g. c:\temp\nene.jpg) into client machine with a OpenFileDialog(image.png).

 

Thank you in advance.

 

Continue Reading
Megumi Kakechi's picture
Post by Megumi Kakechi 11 July 2016
Last answer 13 July 2016 Last comment 13 July 2016
0   0 0
3

answers
2

comments
560

views

0

rating

Hello, guys!

I want to get access to the folder where all files of the namespace are stored using COS. I found a way to get access to class files and found a folder where all csp, html, css etc files are stored.

However, is there any folder which contains all files(even .mac and .int)?  

Or, probably, there is a method which gives all files content?

Continue Reading
Rustam Ibragimov's picture
Post by Rustam Ibragimov 13 July 2016
Last answer 13 July 2016
+ 1   0 2
2

answers
0

comments

175

views

+ 1

rating

I've been trying to write a method to compare two local variables, which may be arrays, for "equality" - that is, to see if they have all the same subscripts (if they're arrays) and values. This is the best I've come up with so far - are there any better/simpler approaches out there?

Continue Reading
Timothy Leavitt's picture
Post by Timothy Leavitt 8 July 2016
Last answer 11 July 2016
+ 1   0 1
6

answers
0

comments

667

views

+ 1

rating

NewBie's Corner Session 12 Do and Goto

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

InterSystems Caché provides a GUI (Graphical User Interface) based Integrated Development Environment (IDE) called Caché Studio. Developers can use Studio to create and maintain applications.

Controlling Process Flow

Controlling Process Flow means controlling the execution path of code. The execution of code flows from the top to the bottom in a routine, except for the following:

Continue Reading
Mike Kadow's picture
Post by Mike Kadow 10 July 2016
0   0 1
0

comments

154

views

0

rating

Does anybody know how can I get the DocumentId property from a DocDM repository using SQL?. So far my SQL is like this:

SELECT name,email,gender FROM JSON_TABLE(
  'person',
  '$' COLUMNS(
    name VARCHAR(100) PATH '$.name',
    email VARCHAR(100) PATH '$.email',
    gender VARCHAR(2) PATH '$.gender'
  )
) 

Thanks!

Continue Reading
Claudio Devecchi's picture
Post by Claudio Devecchi 7 July 2016
Last answer 8 July 2016 Last comment 8 July 2016
0   0 1
1

answers
1

comments
171

views

0

rating

NewBie's Corner Session 11 Routine Line Types and Gotos

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

InterSystems Caché provides a GUI (Graphical User Interface) based Integrated Development Environment (IDE) called Caché Studio. Developers can use Studio to create and maintain applications.

In this session we will cover Routine Line types; which are Label lines, Executable code lines and the Routine Header line as well as Gotos.

Continue Reading
Mike Kadow's picture
Post by Mike Kadow 7 July 2016
0   0 1
0

comments

177

views

0

rating

I am writing a static SOAP response to simply test connectivity. The end users is getting an error "Message: The processing instruction target matching [xX][mM][lL] is not allowed.", which I believe is related to white space. if I observe the response, it looks like there are two blank lines between the header and the body, which I'm guessing is the white space problem. But I can't seem to get rid of it.

Any ideas?

Code:

Continue Reading
Paul Riker's picture
Post by Paul Riker 6 July 2016
Last answer 7 July 2016 Last comment 7 July 2016
0   0 1
2

answers
1

comments
528

views

0

rating

I need to pass an equivalent of .Net Dictionary<string, int> instance from .Net to Caché. In the application, the Caché .Net provider has been used so far, so we came up with passing it as an instance of array of data types. However, the only way to fill the array we are aware of is to use its Add() method which invokes a call to the server instance method of the array for every key-value pair inserted.

Continue Reading
Ondrej Hoferek's picture
Post by Ondrej Hoferek 10 June 2016
Last answer 5 July 2016
0   0 3
1

answers
0

comments

427

views

0

rating

NewBie's Corner Session 8 Not

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

Click on the Caché Cube in your system tray and select Terminal to try out these commands.

NOT operator ('), single quote or apostrophe 

The "NOT" operator reverses the truth-value and is intended for numeric operands, however it can be used on alphanumeric operands.

Continue Reading
Mike Kadow's picture
Post by Mike Kadow 20 June 2016
Last comment 4 July 2016
0   0 4
9

comments
309

views

0

rating

在Aix7.1上安装使用root用户安装cache2016.1.1.107，且在安装过程中创建cacheusr用户；更改操作系统上的cacheusr的umask后，通过数据库修改编译后的文件(如，js，csp等)在小机上查看权限不变（-rwxrw-r--  cacheusr cacheusr test.js）。

目的：通过数据库编译后的文件的other用户有读写权限。

Continue Reading
Yongfeng Hou's picture
Post by Yongfeng Hou 1 July 2016
Last answer 3 July 2016 Last comment 1 July 2016
+ 5   0 2
1

answers
1

comments
405

views

+ 5

rating

Hello!

In Caché there is a way to print all current variables using write command without arguments:

USER>set Einstein = 1879
USER>set Mozart = 1756
USER>write
Einstein=1879
Mozart=1756

But is there a way to get a list of this variables? I am looking for something that would return value like $LB("Einstein", "Mozart") for this case.

Thanks!

Continue Reading
Nikita Savchenko's picture
Post by Nikita Savchenko 14 June 2016
Last answer 30 June 2016 Last comment 30 June 2016
+ 2   0 1
4

answers
12

comments
884

views

+ 2

rating

Hi, after installed Healthshare 2015.2, all the tables previously correctly listed working with Healtshare 2014.1 are NOT listed anymore. TrakCare tables are not listed in the catalogue, nor by the WinSQL Intellisense.

Does anybody know a trick or have a hint to resume this useful functionality back?  

Thanks.

Continue Reading
Alessandro Venzi's picture
Post by Alessandro Venzi 30 June 2016
Last comment 30 June 2016
0   0 4
0

answers

8

comments
310

views

0

rating

Hi!

Here is the question in Russian Forum regarding roots extracting.

In Caché ObjectScript we use exponentiation operator (**) to raise an exponent to power. F.e. let's raise 3 to power of 3: 

USER> write 3**3 

27

And we use the same operator to extract the root. 

USER> write 27**(1/3) 

2.999999999999999963

And 2.999999999999999963 is not 3, obviously.

How to extract roots properly in Caché ObjectScript?

 

 

 

Continue Reading
Evgeny Shvarov's picture
Post by Evgeny Shvarov 23 June 2016
Last answer 24 June 2016 Last comment 28 June 2016
0   0 0
2

answers
3

comments
249

views

0

rating

I have a MySQL server with "posts" table.

I also have a Caché server with "downloadedposts" table. 

They are connected from Caché to MySQL via SQL Gateway

I want to keep Caché table synced with MySQL one  (MySQL "posts" table is a master copy), so periodically Caché queries MySQL server and downloads data. So far so good, and if a record appears or changes in MySQL table, Caché downloads the changes.

The problem I'm encountering is that sometimes rows would be deleted from  MySQL "posts" table.

How do I synchronize deletions?

Continue Reading
Eduard Lebedyuk's picture
Post by Eduard Lebedyuk 23 June 2016
Last answer 27 June 2016 Last comment 24 June 2016
+ 2   0 1
3

answers
1

comments
614

views

+ 2

rating

Steve Glassman is on vacation today so in his place I wanted to announce the availability of a new kit for the 2016.2 Field Test. The kit details are: 2016.2.0.665.0

There is a wide range of changes to the 2016.2 Field Test, 145 of them in total.  You can find a complete listing here:

https://wrc.intersystems.com/wrc/WRC.StreamServer.cls?FILE=/wrc/FieldTes...

Bill McCormick

Director of Product Management

Continue Reading
Bill McCormick's picture
Post by Bill McCormick 27 May 2016
Last comment 27 June 2016
0   0 0
4

comments
261

views

0

rating