#Caché

Index to Articles

Under Construction

Index to Articles

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!

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.

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.

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.

what is difference b/w zbreak and break ?

with some examples.

Exactly a year ago I posted this article about how it's possible to define mappings for packages, routines and globals in one place and have them apply to (almost) every namespace.

Hi,

I would like to list out unchecked mapped items ( classes in management portal )  classes of a particular namespace. Is there any code or terminal command which i can use ?

I am able to list out classes of namespace . But I need to list out unchecked mapped items classes

do ##class(%SYSTEM.OBJ).GetClassList(.result)

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:

test

code

Hi, I don't know if there is a bug in the function $zdate.

if i do:
w $zd("43433",4)  the result is    01/12/59

but if i do:
w $zd("64448",4) the result is   14/06/2017
 

Hi,

I am new to Intersystems Cache. I have a requirement to replace $ZF("%ZSET_DIR","/hold/rsm") using Cache Class. Which class and which method i need to use

Thanks & Regards,

Sadagopan TS

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.

My CSP app uses <IMG> to display images that are on a network drive mapped on my server.  In addition to the virtual path that already exists for my CSP app, should I create another virtual path to the root of the images I want to display

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.

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.

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?

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.

hi ,

     How to install and configure intersystem cache ODBC in CENTOS7 linux box.

 Thanks,

sansa.

Index to Articles

Under Construction

Index to Articles

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.

test

@evgeny test

test

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

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.

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   ü , é , ó , à , .

The following code snippet contains a class method "test" that determines the value of a specified property for an instance of its class:

/// get property value within class by indirection
Class objectscript.getPropOfThisClass Extends %RegisteredObject
{
// extra code to help test
Property myProp as %Integer;
// need to instantiate an object to access property value
method test() {
	// extra code to help test
	set .

Hi all,

    i need one help regrading telnet.In cache 5.02 while we take telnet it open some program(By using ^login Global in %Sys nameSpace).But i could not create same process in cache 2016.

example:

telnet 127.0.0.1 it open some routine in "TRAIN" namespace.

Thanks,

Sansa.