#Caché

30 Followers · 4.6K Posts

  

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

Documentation.

Edit
Question prabakaran a · Feb 14, 2017

Hi All,

          while i configure the shadowing.i got following error.         

ERROR #1043: Shadowing is unavailable for current license

Thanks,

Prabakaran A. 

3
0 37
Edit
Article GUILHERME CRUZ DA CUNHA · Jun 18, 2018 2m read

For those who are interested, or want to do something different with the cache language, I leave here two codes of animations.

They serve to run on the terminal while executing a routine, or a method.

To escape the monotony of seeing that static code in the terminal.

2
0 25
Edit
Question sansa stark · Nov 28, 2016

hi all,

        how to configure the crystal report in iis?

        how to generate the crystal report via intersystem cache ?

info :

  sap crystal report 2011

  iis 6 and windows 3 server

cache 5.02

Thanks,

sansa.

0
0 22
Edit
Question Theunis Pretorius · Nov 5, 2016

How do I call an excel report class from another class and name the report from the call class in cache?

This is the Report Class:

/// ProjekCin.Cinema.report.report
Class ProjekCin.Cinema.report.OLSQL16REP Extends %ZEN.Report.reportPage
{

/// Class name of application this report belongs to.
Parameter APPLICATION = "ProjekCin.report.Browse";

/// Specifies the default display mode used for this report if
/// the URL parameter, <var>$MODE</var>, is not present.
3
0 31
Edit
Article Jose Ruperez · Dec 16, 2016 1m read

The first step when dealing with performance is the ability to measure it. In this article, we will show you a way to measure the performance of your CSP and/or ZEN applications. You will be able to answer questions such as: Which pages of my application are hit the most? or Which pages in my application are the slowest?

1
0 21
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
Article John Lambert · Apr 5, 2016 1m read

One of the internal changes in Cache 2016.2 is the switch from using Posix asynchronous IO on Linux platforms to native kernel asynchronous IO for improved performance. There is a kernel parameter that controls the maximum number of events that can be handled across the entire system and it is possible to hit this limit on newer versions of the Linux kernel when Cache is setting up disk IO structures in the WD or user processes. To prevent this from occurring we recommend that the kernel parameter 

0
0 0
Edit
Article Alexey Maslov · Nov 12, 2016 14m read

This article is about how to gain as much transparency in controlling processes in ECP environment as in traditional (non ECP) one.

The technology of load balancing between several servers with relatively low capacity has been a standard feature of Caché for quite a while. It is based on the distributed cache technology called ECP (Enterprise Cache Protocol); note that we are referring to “cache”, not “Caché”, here. ECP provides a host of possibilities for horizontal scaling of an application, ensuring high performance and fault-tolerance, and yet keeping the project budget fairly low. Another apparent advantage of ECP network is the possibility to conceal its architecture in the depths of Caché configuration so that applications developed for the traditional (vertical) architecture can be fairly easily migrated to a horizontal ECP environment. The ease of this process is so mesmerizing, that you start wishing it was always this way. For instance, everybody is used to having a possibility to control Caché processes: the $Job system variable and associated classes/functions work magic in skilful hands. Stop, but now processes can end up being on different Caché servers… The text below is about how I managed to cope with this problem.

0
0 0
Edit
Question Ferran Olle · Nov 23, 2016

Hello,

Our Intersystems Cache database is running in a Windows 2008 R2, and is installed and configured as "UNICODE" .

We are using Apache+PHP with  ODBC to get data but we have some problems with character encoding.

We also have two configurations:

  • Ubuntu 16.04 LTS + Apache2 + PHP 5.6 + UnixODBC
    • using isql command everything works fine, data returned is OK   (all special characters  in Spanish displayed ok).
    • using PHP with  PDO function to connect the database and libcacheodbcu35.so driver
      • with  default_charset=""  in  php.ini
      • Special characters in spanish not displaying   (  like   ü , é , ó , à , .
2
0 63