#Caché

30 Followers · 4.6K Posts

  

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

Documentation.

Edit
Article Mike Kadow · Jul 22, 2016 2m read

NewBie's Corner Session 14 Inline Do & Nested Do with Implied Quit and For Loop

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.

The following concepts of Inline Do, Nested Do, Implied Quit and For Loop is difficult to explain in a manner that everyone understands. However, these concepts work well with each other.

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 Gevorg Arutiunian · Jul 13, 2018 1m read

This code snippet uses GZIP to compress and decompress a file in the file system. Change default file paths to customize code to compress/decompress your files:

Class objectscript.GZIP Extends %RegisteredObject
{
	classmethod test() {
		//Export Global(s) uncompressed
		set filename="C:\Temp\myglobal.xml"
		do $System.OBJ.Export("^oddEXTR.gbl",filename)
		//Open exported Globals
		set uncompressed = ##class(%FileBinaryStream).%New()
		set uncompressed.Filename=filename
		Set compressed = "C:\temp\mycomglobal.xml"
		//Open File Device over Gzip and Copy Uncompressed information to it
		Open compressed:("WUNK":::/GZIP=1:/NOXY=1:/OBUFSIZE=32768):0
		Use compressed
		do uncompressed.OutputToDevice()
		close compressed
		//Create New File  
		set out = ##class(%FileBinaryStream).%New()
		set out.Filename= "C:\Temp\decomp.xml"
		//Open compressed File and save information uncompressed over gzip
		Set file=##class(%File).%New(compressed)
		Do file.Open("RUK:::/GZIP=1:/NOXY=1")
		while ' file.AtEnd
		{
		    set line = file.ReadLine()
		    do out.Write(line)
		}
		do out.%Save()
	}
}

GitHub: https://github.com/intersystems-community/code-snippets/blob/master/src/cls/objectscript/GZIP.cls

0
0 0
Edit
Question sansa stark · Dec 8, 2016

Hi All, I am taking a namespace and routines from one table for particular user.if the user have name space and routine means it execute well but after executed the routine it is automatically quit and close the session.I need to keep the same namespace after executing the routine. Please help to proceed further anyone.

2
0 16
Edit
Question sansa stark · Dec 1, 2016

Hi All, I configured the crystal report SAP 2011 with IIS 10 in windows server 2012 r2 standard,when I tried to open it shows failed to open the connection error .database is Cache.how to recover that problem.

0
0 15
Edit
Question Davidson Espindola · Mar 3, 2017

Hello everyone,

I have the following problem in generating a PDF report in ZEN, which has many items, a general total of approximately 30,000 items, but gives an error, I can generate a report with a maximum of 8,000 items, which may be wrong.

==========

Class Ideal.ListaEstoquePDF Extends %ZEN.Report.

0
0 0
Edit
Question Chris Thompson · Dec 20, 2016

Currently we have a setup where we have an external IIS webserver that our CSP Gateway sits on that routes requests to our ensemble server. When working with soap everything was routed to the CSPms module since the site's handler mappings have *.cls going to this module. However, now that we are working with rest services that don't have a file extension we will have to have all traffic on the IIS box be routed through the CSPms module. 

I was curious if anyone has encountered this type of issue, and if so, what steps did they take to resolve it?

0
0 4
Edit
Article GUILHERME CRUZ DA CUNHA · Jun 15, 2018 2m read
  1. What is this talk? • Provocative • Conflicting • Irritating • For those who want to be professional • Driver

  2. What is this talk not? • Silver bullet • Only for devs Java • Only for devs • To be forgotten

  3. Debt technical or "how to prevent the conductor knock on your door" - Alexandre Freire https://www.infoq.com/br/presentations/divida-tecnica- need-credit

  4. Developers do not know fundamentals!

  5. http://s3.amazonaws.com/magoo/ABAAAfWwoAD-5.jpg

  6. bitly.com/resultadopesquisafusca bitly.com/pesquisafusca

  7. Developers do not know how to make simple software!

0
0 17
Edit
Article Cameron LaHart · Nov 22, 2016 2m read

Configuring Java with InterSystems Technology

Regardless of what InterSystems technology you use to design your applications, it is likely that some of our product functionality will require that Java be installed on the operating system, and subsequently be configured properly with your InterSystems based application. There are many ways that this can be accomplished depending on your operating system, as well as the specific InterSystems technology you are integrating with.

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