#Caché

InterSystems Caché is a multi-model DBMS and application server. See more details here.

By update

Question

John Murray · Aug 25, 2016

The FT keys InterSystems currently make available to us in the zips from the download pages are due to expire at the end of this month (31-Aug-16). Will there be new keys soon?

Also wondering when we might expect new FT builds for 2016.2 and 2016.3. The last published ones were 24-Jun-16 and 16-Jun-16 respectively.

I haven't seen an Atelier update for a while either.

#Caché #Ensemble #Field Tests

1 2

0 343

InterSystems Official

Steve Brunner · Aug 2, 2016

2016.1.2 Maintenance Release

InterSystems is pleased to announce that Caché and Ensemble 2016.1.2 are now available as maintenance releases.

For a complete list of the corrections in 2016.1.2, please review the release notes.

#Release #Caché #Ensemble #InterSystems Official

1 2

0 601

Question

Tamara Lebedeva · Aug 22, 2016

$fromJSON and MAXSTRING

Hi, all.
I have CSP application and it needs to get and process data from ajax request with json-content. JSON can be very big.
In this case:
TRY
{
Set RequestObj = ##class(%Object).$fromJSON(%request.Content.Read())
} CATCH(Exception) {
Set Status=Exception.AsStatus()
}
I get just part of getting JSON and validate error in $fromJSON.
If I try to read it all in cycle:
TRY
{
While (%request.Content.AtEnd = 0) {

#Caché #JSON #CSP

0 6

0 1.5K

Question

Sebastian Mueller · Aug 25, 2016

Iterate through global

Let's imagine I have a global like this:

^Users(12, "SETTINGS", "IsAllowed") = 1

^Users(41, "SETTINGS", "IsAllowed") = 0

^Users(52, "SETTINGS", "IsAllowed") = 1

Now I would like to check for each user whether they are allowed, therefore I'd need to iterate through the Global. How to do that? It seems that I can't use $Order here like such:

S FF = ""
For {
S FF=$O(^Users(FF,"SETTINGS","isAllowed"))
Q:$L(FF)
W "User ",FF," is allowed",!
}

Is there any other way of doing this?

#Globals #Caché

0 5

0 1.1K

Question

Ponnumani Gurusamy · Aug 11, 2016

Cache with server page

Dear Sir ,

how to i run csp file . sometime csp file runs as at a time appear "Error #670: could not attach to target".How to solve it. Thank you

#Caché

0 2

0 415

Question

sansa stark · Aug 24, 2016

How to access InterSystems Caché after installation

Hi All,Now I installed the Cache 5.0 that terminal is not open can any one know the default username and password for Cache 5.0

#Caché #Terminal

0 2

0 383

Question

Rustam Ibragimov · Aug 12, 2016

Export and Import Web Files

Hello, guys.

I need to find all web files, get their content in UDL format and to be able to export them. And, vice versa, to be able to import them in udl format.

I know that they are located in CSP folder. However, is there any way to do this using COS functions?

#Data Import and Export #Object Data Model #ObjectScript #Caché

1 2

2 662

Question

Nikita Savchenko · Aug 24, 2016

Caché Installation Unique Identifier

Hello community!

Is there any method/property/way in Caché to obtain something like unique identifier for installed Caché system? The idea is to get the identifier that will differ on any other installation/machine/etc, but will forever remain the same for the current installation, even if $zv changes (in case of update) or any data is removed from the database.

#Caché #ObjectScript

0 2

0 449

Question

Chip Gore · Jun 28, 2016

Joins in SQL Computed Code specification?

Hi -

I have 3 classes: "Class A" has a property X, "Class B" has a property which is a Class A, and I have a "Class C" which has a property of a Class B.

Class A definition

Class USER.ClassA Extends %Persistent

{

Property Propx as %String;

}

Class B definition

Class USER.ClassB Extends %Persistent

{

#Object Data Model #ObjectScript #Caché

0 5

0 344

Question

Ponnumani Gurusamy · Aug 17, 2016

Rules for arithmetic operators in Caché

write "5apples" + "7 orange" //Ans :12

Values are string , why add numeric value . its an error or correct . please tell me.

#Caché #ObjectScript

0 7

0 452

Question

Paul Riker · Aug 24, 2016

cacheStream Table

I ran %GSIZE and my ^cacheStream global is very large. How do I go about

1. Evaluating what data is in the global.

2. Clean it up.

Thanks!

#Globals #Object Data Model #Caché

0 1

0 667

Question

Derek Day · Aug 16, 2016

image/png support for Zen Reports / Apache FOP

Has anyone configured Zen Reports/FOP to support png images? If you have, could you please share the library that you used, the configuration required, and whether it was worth it (vs converting images to one of the natively supported formats)?

#ZEN #Caché

0 3

0 654

Question

Alberto Arias · Aug 23, 2016

SQL query case insensitive

I try it with the COLLATE instruction, but doesn't work.

Any ideas ?

Tkanks.

#SQL #Caché

0 3

0 892

Question

Jose Antonio Ca... · Aug 18, 2016

Use current loged user to authenticate client Ajax call

Hi,

We are trying to implement a client side data provider as a component (ZEN) that will use JQuery to do rest calls to a desired URL, in this case, a %CSP.Rest service implemented by ourselves.

This component will be used within our application that is authenticated with a correct user configured on Caché management portal and therefore using one license unit. As we are using a Ajax call from client side this connection creates a new session that will use a new license.

#REST API #Authentication #Caché

0 2

0 595

Question

Jose Antonio Ca... · Aug 1, 2016

Debug mode execution on a deployed code

Hi all,

For custormer support reasons we would like to know if its possible to activate some kind of flag or see/redirect wich is the code (lines) being executed when some misterious problems appear.

Is there any way to view the stack of execution code on a deployed code environment? Is there any other equivalent way to track the execution stack for a certain period of time?

Best regards

#Caché #Debugging

1 5

0 416

Question

Renee Cannon · Mar 28, 2016

Is there an API for determining the size of a routine?

Is there an API I can call to determine the size of a routine in a CACHE.DAT file so that I don't have to directly reference the ^ROUTINE global?

#Databases #Object Data Model #ObjectScript #Caché

0 4

1 543

Article

Mike Kadow · Aug 13, 2016 3m read

NewBie's Corner Session 17 New command

NewBie's Corner Session 17 New command

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

New command

The New command limits a variable's scope or range of use. In theory the New command is simple, in reality the New command is powerful and needs to be respected and understood. In Caché ObjectScript and MUMPS an entire chapter is devoted to it.

There are three variations of the New command:

When used without variables

#Beginner #Caché

0 7

0 546

Question

Ponnumani Gurusamy · Aug 18, 2016

What does $horolog function do?

Please Explain "$h"

#ObjectScript #Caché

1 3

0 481

Question

Ponnumani Gurusamy · Aug 18, 2016

Cache MAC routine

Difference Between Macro and routine?

#Object Data Model #Caché

0 2

0 1.2K

Question

Ponnumani Gurusamy · Aug 18, 2016

How to run mac routines from terminal?

I wrote a macro in studio. Its how to run with Terminal.

do macro name ^filename is correct are not

#Caché #Studio #Terminal

0 1

0 1.9K

Question

Ponnumani Gurusamy · Aug 17, 2016

InterSystems Ensemble vs DeepSee

what are the difference between Deepsee and Ensemble , and how to access the ensemple .Please Tell me

#Caché #InterSystems IRIS BI (DeepSee) #Ensemble

0 3

0 454

Question

Ponnumani Gurusamy · Aug 12, 2016

Cache with database

Sir, please give a sample program for cache with database . It is useful for my individual learning.

#Object Data Model #Caché

0 2

0 347

Question

sansa stark · Aug 16, 2016

CSP Session

Can anyone explain me how to create a dynamic session in CSP?

#Caché

0 3

0 471

Article

Eduard Lebedyuk · Aug 9, 2016 2m read

Tips & Tricks - Process-private Globals as a class storage

Process-private Globals can be used as a data global in storage definition. That way, each process can have its own objects for the class with ppg storage. For example lets define a pool, which can:

add elements to a pool (ignoring duplicates)
check if an element exists in the pool

Here's the class:

#Code Snippet #Data Model #Globals #Object Data Model #ObjectScript #Tips & Tricks #Caché

4 2

0 925

Question

Ponnumani Gurusamy · Aug 11, 2016

Beginner of Cache

I am learning cache in beginning level . But confused .Give an idea for how to i learn cache easily and improve programming level

#Caché

0 4

0 713

Question

Laura Cavanaugh · Aug 11, 2016

Calling javascript method from Zen method, with parameters

I'm running into difficulty calling a javascript method from a Zenmethod. I pass in a parameter, but in the javascript method the parameter is undefined. Here is the code:

...

#JavaScript #ZEN #Caché

0 9

0 1.6K

Article

Evgeny Shvarov · Jul 14, 2016 1m read

Caché Haiku

Alex Koblov posted today a #CachéHaiku:

Full command names

Make your code more readable

Than compact versions

My haiku:

Caché Globals

Shows you keys to the value

If you $order it

Your variant? ;)

#Caché

8 19

1 1K

Article

Mike Kadow · Aug 12, 2016 2m read

NewBie's Corner Session 16 Introduction to New Concepts

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

A number of new concepts are introduced in this session that will be developed more fully in subsequent sessions. It is necessary to at least introduce these concepts here because they are all interrelated.

Older style of MUMPS Programming

#Caché

0 0

0 257

Question

Eduard Lebedyuk · May 23, 2016

REST and IO redirection

Problem: I have a REST broker, and if I hit a code block, which does IO redirection, the REST reply becomes broken in one of the following ways: