#Caché

30 Followers · 4.5K Posts

  

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

Documentation.

Edit
Article Thomas Carroll · Sep 17, 2016 2m read

Embedded SQL is a tool that allows us to execute SQL statements in Caché Object Script. For example, to select the name of a person with a particular SSN from the Sample.Person class

&SQL(

SelectNameinto:tName

FromSample.Person

WhereSSN = :tSSN

)

The colon syntax is used to identify local variables, in this case tName and tSSN. &SQL indicates to our compiler that this is SQL syntax. At compile time, this statement will be optimized to executable Object Script code. More about this syntax can be found here.

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_esql

SQLCODE

0
0 0
Question Neeraj Mehta · Sep 15, 2016

I have been using the query below and it was working fine but now it's giving a SQL error. There were no changes made that could cause this to stop working. There is no Field 'APPLICATIONID' in the table.

QueueSQL=select distinct (convert(char(5),SkillsetID)+'='+Skillset) from iagentbySkillsetStat where ApplicationID > 10000
QueueMappingSQL=SELECT DISTINCT (convert(char(5),SkillsetID)+'='+Skillset), SkillsetID FROM iagentbySkillsetStat iagentbySkillsetStat WHERE (iagentbySkillsetStat.ApplicationID>10000)

DB- Intersystems Cache

Error details for the log files are below.

6
0 4438
Question Eduard Lebedyuk · Sep 16, 2016

Let's say I have a global named ^a and I need to export its nodes 1, 2, 3, 5 only.

Currently I write something like this:

Write $SYSTEM.OBJ.Export("a(1).gbl,a(2).gbl,a(3).gbl,a(5).gbl", "C:\Users\eduard\Desktop\a.xml")

Is there a way to write it shorter? I want to write global node once and list all the subscripts I need.

1
0 774
Question sansa stark · Sep 14, 2016

Hi,

  I was set one session in user namespce (%session.Data("sup")="login User ").but i couldn't get this session(%session.Data("sup")) in  another namespace.

Cache version:cache 16

but i can acces in cache 5.02.

4
0 1153
Question sansa stark · Sep 15, 2016

Hi All,Cache is not starting ,I checked the cconsole log it is showing the below error. The following parameters are missing from section [Journal]: '2,12' at line 143,but i checked in last cpf file, In cpf file consist of that particular line [Journal] AlternateDirectory=C:\InterSystems\CACHE16\mgr\journal\ BackupsBeforePurge=2 CurrentDirectory=C:\InterSystems\CACHE16\mgr\journal\ DaysBeforePurge=2 FileSizeLimit=1024 FreezeOnError=0 JournalFilePrefix= JournalcspSession=0

2
0 435
Article Jonathan Schulman · Sep 14, 2016 4m read

A “Dummy” SOAP Web Service

When dealing with SOAP in Caché, it is sometimes necessary to debug errors by directly accessing (and sometimes editing) the XML which is sent, i.e. the SOAP request and subsequent SOAP response. If you’re debugging a Caché web service, it is often useful to use a tool such as SoapUI (https://www.soapui.org/) to manually create and control the SOAP request, so that the effect of adjustments can easily be seen on the Caché web service.

0
1 4130
Question Ponnumani Gurusamy · Sep 7, 2016

Caché Application Developer certification:

How to I prepare developer certification of cache .What are the topics are preparing certification . Please give the topics .I will start learning of certification course .

3
0 1715
Question Marek Bernád · Sep 12, 2016

Hello community,

Is there a way in Caché to trigger some method when any class changes? For example, if I edit any class in any namespace, when I save this class I want some method to be triggered with the class name parameter or any available data about the class.
Concretely, I tried to add a %OnAfterSave() callback to the %Dictionary.ClassDefinition  class, but this method is not triggerred when any class saved as I expected. I am writing a project in Caché and the purpose of my project is to show editing history of the edited classes in the Caché studio.

Thank you in advance for your response.

2
0 655
Edit
Question sansa stark · Sep 12, 2016

Hi ,

     The below code is working in cache 5.02 but it'snot working cache 16.

      while we calling this method in another csp page it's show some different character.

1
0 24
Question Jose Antonio Cañizares · Sep 9, 2016

Hi all,

Do anyone know how to force to close the CSP connection used before redirecting to a different page so a new connection ( and therefore a new session id) is generated?

The idea is to generate new CSP session once we log off our application so the session identifiers are different.

Best Regards

4
0 606
Article Mike Kadow · Sep 10, 2016 3m read

NewBie's Corner Session 26 Globals and Arrays Part 2

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

Globals, Arrays, and Variables Part 2

A thorough understanding of Globals, Arrays, and Variables is foundational for every Caché developer.

Uniqueness of the Caché Global Structure or database

0
0 417
Question sansa stark · Sep 9, 2016

Hi ,

  We upgraded the cache 5.02 to cache 16.
  we are using stream property in one class .(i.e.  Property notes As Stream;) but it not support in cache 16.
 how handle this problem?

Thanks, sansa.

4
0 502
Question Laura Cavanaugh · Sep 9, 2016

I know %CSP.Daemon is supposed to clean up old CSP sessions (?).  In my management portal, under System/ License Usage, I see 33 "Units" used (and there are 33 licenses  in use), but usernames from old IP address and that are not being  used.  Their active times are often in the millions of seconds.  They are not "on" the system right now.  

At most, only 3 users are on the system right now.

Are these supposed to be cleaned up?  Can I clean them up programmactially, and how would I know if they're not active?

Thanks,

Laura

8
0 1307
Question Ponnumani Gurusamy · Sep 8, 2016

Why we are not using database of join (inner join and outer join) concept. How to we are retrieving the data from different tables in cache. Any Concepts are using in Cache database to retrieve the data.

5
0 486
Question sansa stark · Sep 8, 2016

Hi ,

We upgraded cache 5.02 to cache 16.In this version it is having problem with "$$$" macros.

These are the error's eating my time. i tried to figure it out but there is no exact solution .

MPP5610 : Referenced macro not defined: 'CSPSessionTimeout'
MPP5610 : Referenced macro not defined: 'CacheError'

I checked the check list also "These macros will be the only ones displayed by StudioAssist when the sequence, “$$$”, is recognized during program input. The full set of macros and their definition can be displayed via the $SYSTEM.OBJ.ShowMacros method"
3
0 323
Job Digi Thespis · Sep 8, 2016

Wir suchen für ein Unternehmen unserer Firmengruppe

eine/n ERP System Developer / Programmierer/ Software Entwickler

Unser Partnerunternehmen ist ein international agierendes Handelsunternehmen mit Sitz in der Nähe von Wien.

Der zukunftsorientierte IT Bereich entwickelt intelligente innovative Lösungen für die Vielfalt der Herausforderungen, die sich täglich stellen. Die Fülle der abwechslungsreichen Aufgaben und Projekte, sowie die Art und Weise wie zusammengearbeitet wird, bietet hervorragende Wachstums- und Entwicklungschancen.

0
0 685
Article Mike Kadow · Sep 7, 2016 3m read

NewBie's Corner Session 25 Globals, Variables, and Arrays Part 1

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

Globals, Arrays, and Variables

A thorough understanding of Globals, Arrays, and Variables is foundational for every Caché developer.

A Global may be:

Scalar (a single element), as in a Global Variable

Example of Global Variables
Set ^PERSON = "DAVID – DATA ABOUT DAVID"
Set ^PERSON2 = "MICHAEL – DATA ABOUT MICHAEL"
Aggregate (many elements), as in a Global Array. An Array combines similar elements together.
Example of an Global Array
0
0 562
Article Bob Binstock · Sep 7, 2016 6m read
Mirror Outage ProceduresCaché mirroring is a reliable, inexpensive and easy to implement high availability and disaster recovery solution for Caché and Ensemble-based applications. This article provides an overview of recommended procedures for dealing with a variety of planned and unplanned mirror outage scenarios. (For detailed information about mirroring and a wide range of mirror-related procedures, see Mirroring 101.)A Caché mirror typically consists of two Caché instances on physically independent hosts, called failover members. (A mirror can also be configured with a single failover
0
1 1227
Question Tony Beukes · Sep 7, 2016

A question from Benjamin Linden:

We are looking to upgrade the hardware for our server.

Do we need to buy a new Caché license? Or can we keep using the one we have?
 

2
0 368
Question Markus Neumann · Sep 2, 2016

Dear Colleagues,

Recently I am working on a Cache project should enable the customer, to update our Cache application independently from us. Our idea is a client (preferred .net) application that will copy all the necessary Cache stuff (classes, routines) into a cache database. For this, we are looking for the appropriate technology – in old times this would be a CacheDirect.

4
0 706
Question Laura Cavanaugh · Sep 6, 2016

If a user simply closes a tab (running a web application), is there any good way to ensure that the license is released AND the login cookie is destroyed?  

I found that if the tab is simply closed without first logging out of the application, then 1) the license hangs around forever, and 2) if the user then opens a tab, he is already logged in.

For #2, I understand that there might be some grace period to allow the user to log in automatically again using the same session Id (where is that documentation again?) but what about destroying the license?  Who/what is supposed to clean that up?

5
1 1976