#Caché

30 Followers · 4.6K Posts

  

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

Documentation.

Edit
Question Nicole Kristen · Oct 13, 2017

AI can be categorized in any number of ways, but here are two examples.

The first classifies AI systems as either weak AI or strong AI. Weak AI, also known as narrow AI, is an AI system that is designed and trained for a particular task. Virtual personal assistants, such as Apple's Siri, are a form of weak AI.

Strong AI, also known as artificial general intelligence, is an AI system with generalized human cognitive abilities so that when presented with an unfamiliar task, it has enough intelligence to find a solution.

0
0 16
Edit
Article Andrey Rechitskiy · Nov 22, 2018 13m read

As you know, Caché can be used as a relational DBMS working with JDBC/ODBC drivers and supporting the execution of arbitrary SQL queries and SQL procedure calls. 

We also know that Caché stores all the data in multi-dimensional sparse arrays called globals. It allows the developer not to use the standard CachéSQL engine in case a particular SQL procedure is underperforming, but instead rewrite its execution code in the Caché ObjectScript (COS) language intended for server-side business logic. This approach may help implement the optimal SQL procedure execution algorithm by using better-optimized NoSQL data structures (globals).

However, the standard class library in Caché has one limitation: for SQL procedures where data selection is controlled by custom COS code, you need to define the set of returned fields at the compilation stage - i.e. it is impossible to dynamically define metadata for an SQL procedure working with NoSQL structures. This article is about how to get around that limitation.

0
0 0
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(

Select Name into :tName

From Sample.Person

Where SSN = :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?

0
0 0
Edit
Question Peter Kopp · Oct 11, 2016

Good morning, I am using a <Image/> tag, in a <Tab/> tag, of a <TabGroup/> to render a tif image. I would like the tif file to be rendered full size. However, I have not been able to achieve this using the height="100%"  and width="100%" parameters available. All I get is an envelope with scroll bars, with perhaps a quarter of the image visible at any one time. Thank you in advance for any and all feedback.

2
0 18
Edit
Article Katherine Reid · Jun 15, 2016 1m read

Question

 What version of Caché supports TLS v1.2? 

Answer

Caché uses the openssl library for SSL/TLS support.  On Windows, Linux and Unix, a version of this library is included with the install kit.  Caché 2014.1.3 and 2015.1.0 ship with the openssl 1.0.1j library.  TLS v1.1 and v1.2 support is first available in openssl version 1.0.1, so Caché 2014.1.3 and 2015.1.0 are the first versions to allow the use of TLS v1.1 and v1.2.

On these versions, if the "TLS v1" checkbox is checked in an SSL/TLS configuration, the system will use any of TLS v1.0, v1.1 and v1.2 .

0
0 4
Edit
Question Stuart Byrne · Jul 11, 2018

Hello,

I'm just re-going through the Caché foundations course exercises using a copy of Try-Caché on my home pc.

I'm trying to create a web application to receive REST calls however, when I use the Restlet client I get no response.

My web application config is:

0
0 0
Edit
Article Carter Tiernan · Sep 21, 2016 1m read

Overview

The The System Monitor Dashboard project is, most generally, an open source extension to the Cache System Monitor.

More specifically, it allows users to customize the monitoring of a Cache environment as well as how the collected data is visualized.

Goals

  • Displays important system state and historical information in an accessible and useful way.
  • To provide an intuitive and complete API for users to tailor the Cache System monitoring to their specific needs.
1
0 0
Edit
Question sansa stark · Nov 29, 2016

Hi all,

       In Cache 5.02 while creating user the password was encrypted.

      how to decrypt the password in cache 5.02?

       We upgrade the cache 5.02 to cache 2016 ,But the user accuonut  are not updated in cache 16.

      We have created user acconut in login global in "%SYS" namespace .But the password are encrypt.

Thanks,

sansa.

1
0 64
Edit
Article Mike Kadow · Jul 4, 2016 2m read

NewBie's Corner Session 10, Subject: Routines and Studio

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.

InterSystems has a new IDE called Atelier but that is for later.

A Routine is the name that Caché calls computer programs. A Routine consists of a number of lines of instructions to the computer; these instructions are called code.

0
0 2
Edit
Article Chris Stewart · May 6, 2017 2m read

In our last lesson, we added a form to Edit our existing Widgets, and save them back to the server.  However, our Form was not well strcutured and our Save button had no intelligence, and was not fully visible.  So today, we will apply some Material components and Angular style to make the form more useful

Let's open EditWidget.csp, and make some changes.  First, we want to change the component from an md-card to an md-dialog.

0
0 0
Edit
Article Ward De Backer · Jun 23, 2016 2m read

In this article I will show you how to build Universal JavaScript  applications using Caché (sharing your code across front- and back-end). But before we start writing code, I'll first give you some reasons and background why you should consider building your applications using this technology.

As I described in an earlier article on my CODE development blog, applications need to run these days on all kinds of devices and operating systems with different form factors and application development requires a new strategy. One can't keep using platform specific development tools anymore.

0
0 4
Edit
Question Sebastian Thiele · Nov 11, 2016

Hi,

I try to programmatically create a parameter for a dataCombo ZEN Component (which is in turn created on the server side at runtime).

Set tParm = ##class(%ZEN.Auxiliary.parameter).%New()
Set tParm.id = "pRegion#"_pExamContainerCount, tParm.name = "pRegion#"_pExamContainerCount

Set tExam = ##class(%ZEN.Component.dataCombo).%New()
Set tExam.id = "Exam#"_pExamContainerCount, tExam.label = "Untersuchung", tExam.queryClass = "Inventory.ServiceCatalog", tExam.queryName = "QGetExaminations", tExam.showEmpty = "false", tExam.size = "52", tExam.onchange = "zenPage.updateExamDescription(zenThis.

0
0 2
Edit
Article Danny Wijnschenk · Oct 29, 2017 1m read

Advent of Code is a series of 25 small programming challenges, created by Eric Wastl, see https://adventofcode.com/.

There are small and bigger puzzles, which you can solve typically in half an hour to a few hours. (Looking at the leaderboard, the top aces can do them in less than 10 minutes.) 

It's an ideal way for beginners to start learning a computer language, and for advanced people to sharpen their programming skills.

To help you get trained for this year's challenges which start at December 1st, I will try to solve and comment the puzzles from 2016.

0
0 0
Edit
Question Thomas Chericka · Oct 7, 2016

Hi,

Thanks a million for taking the time to read this.

I'm calling the functions $ZF(-`1, <path to EXE>) and $ZF(-2, <path to EXE>) from Cache code. The exact code I'm using in Cache Studio is given below.

/// Test the functionality of ZF(-1) and $ZF(-2), 
Class %SourceControl.UnitTest Extends %Persistent
{
Parameter PATH As %String = "E:\VCS\CommandExecutor\bin\Debug\WindowsApplication.exe";
ClassMethod Test()
{
Do $ZF(-2, ##Class(%SourceControl.UnitTest).#PATH)
}

Now when I run the command in the Cache Terminal, as given below,

>do $ZF(-2, "E:\VCS\CommandExecutor\bin\Debug\WindowsApplication.

0
0 2
Edit
Question Laura Cavanaugh · May 12, 2017

I was looking at the OrefToArray^%occRun in the %CSP.ErrorLog page in version 2016.  However, we're on version 2014, and that method does not seem to exist yet.  I would love a good way to swizzle out the info in the %request, %session, %response objects for the error log for my own error page, in version 2014.  I don't want to have to go through and get all the properties manually, but I will if I must.  Any other good way  already written?

Thanks,

Laura

0
0 0
Edit
Article Tao Sun · Apr 20, 2016 6m read

Recently I have been working on a performance issue reporting about that Sets or Kills in the same global performed by multiple processes in a very focused time period can sometimes take a long time (several seconds) to complete. I feel this is an interesting case study to understand about some performance tunings of Caché.

Case background:

A testing routine creates multiple processes to do set (or kill) random nodes of a global in tight loop and records the timing how long a set (or kill ) operation takes.  For a global with a large number of nodes (e.g.

0
0 0
Edit
Article Thomas Carroll · Sep 17, 2016 3m 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 we can do the following.

&SQL(

Select Name into :tName

From Sample.Person

Where SSN = :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.

0
0 0
Edit
Question Mike Kadow · Apr 26, 2017

I need some help on navigating through the DC.

I never know where I am, what comes next, what was previous.

Do I just mindlessly go from post to post? 

A least when I use to receive email on the posts, I had some control.

0
0 0
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.

      ClassMethod OnHTTPHeader(ByRef OutputBody As %Library.Boolean) As %Status [ ServerOnly = 1 ]
  {
set user $ZUTIL(67,15,$JOB)
set status %session.Login(username"Test" ,1)
set log $Get(%session.Data("Log")) 
set logtype $Get(%session.Data("logtype")) 
if (log "")
{
!, "<div style='color:#000000; background:white; ; font-size=10pt;'><B>Your session has expired.

1
0 24
Edit
Article Carter Tiernan · Sep 21, 2016 2m read

Overview

Current Caché system monitoring functionality provides real-time information about a Caché environment. This allows for preventative measures to be taken before system failure by highlighting specific metrics when they are at unusual or dangerous values. Additionally, diagnosis of past or current erronious events is aided by informative logs that are created by the system monitoring process.

The System Monitor Dashboard project is a successor to the current system monitoring functionality.

0
0 0
Edit
Question Keith McCauley · Nov 24, 2016

Hi,

I've managed to get a zen Report working where it outputs the contents to a pdf file - the pdf has a background image and it works perfectly. I now want to print that PDF from Caché.

I've tried to use the GenerateReport method - mode 12 — Generate a report in PDF format, and send it directly to a printer via the Caché Print Server e.g. sc=rep.GenerateReport("Printdoc.pdf",12)   (where "rep" is my zen report)

I've created the Caché print server in the management protal as per the documentation.

I don't understand where I need to specify the printer that I want to use.

0
0 24
Edit
Question Peter Kopp · Jan 31, 2017

Good morning, I would like to visualize the data summarized in a tablepane in a pieChart widget. Since my tablepane has already executed the query, I would like to use the tablepane snapshot as the data source for the pieChart widget. Is this possible? What would the syntax be for linking the widget to the snapshot look like? Thank you for all input.

0
0 14
Edit
Question Arpitha Ramakrishnaiah · May 11, 2017

Hi,

I would like to know if there is any code to compare and update two directories/namespaces for class files.
If file is present in directory1 and not present in diectory2, it should import the classfile.
If file is not present in directory1 and it is present in directory2, the corresponding file should be deleted from  directory2.

Please suggest code for the task.

Thanks,
Arpitha R

0
0 0
Edit
Question Soujanya Naganuri · Jun 20, 2017

In Oracle sql Developer, you can still listing the records in a desk the use of the statistics tab when viewing a desk. there where can add, delete, edit or just viewing facts of desk currently viewd

the trouble is that we regularly actually need to view a couple of table immediately, then we want more than one tab opened, issue that i dont recognise how to do that, any sugestion. tq earlier

0
0 30