#Caché

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.

Is there any simple code in Cache using FHIR to understand the relationship between them? If so can anyone provide some example.

test post

TEst test

Disclaimer: This is not a how to guide and I personally do not do any of the following unless its for penetration testing. It's important to think like a hacker in order to beat them at their own game.

To start off click on this google search link (its safe)...

https://www.google.co.uk/search?q=cache+error+page&oq=cache+error+page&….

DraftDraftDraftDraftDraftDraftDraftDraftDraftDraft

NewNewNewNewNewNewNewNewNewNewNew

Index to Articles

Under Construction

Index to Articles

Test

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.

Hi All,how to configure Crystal reports in IIS7.

what is difference b/w zbreak and break ?

with some examples.

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

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!

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

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.

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.

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 

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.
Parameter DEFAULTMODE As STRING [ Constraint = ",html,tohtml,toxslfo,pdf,xml,xslfo,excel,toexcel,ps,pdfprint,xlsx,tiff,displayxlsx,fo2pdf,foandpdf", Flags = ENUM ] = "xlsx";

/// Set om multiplesheets te kan save in excel
Parameter EXCELMULTISHEET = 1;

/// This is the optional XML namespace used for the report.
Parameter REPORTXMLNAMESPACE;

/// This is the logical name of this report.
/// If not provided, class name is used.
Parameter REPORTNAME As STRING = "Tutorial";

/// This XML defines the logical contents of this report.
XData ReportDefinition [ XMLNamespace = "http://www.intersystems.com/zen/report/definition" ]
{
<report xmlns="http://www.intersystems.com/zen/report/definition"
 name="report" sql="SELECT 
FTR, ID, Amount, BusinessDate, COARno, Description, Expression, NominalAccountNo, OBJVersion
FROM ProjekCin.LSL" runonce="true">
<group name="SQL161" sql="SELECT 
FTR, ID, Amount, BusinessDate, COARno, Description, Expression, NominalAccountNo, OBJVersion
FROM ProjekCin.LSL WHERE BusinessDate = '20150601'" excelSheetName="1">
<group name="g1">
<element name="No" field="FTR" />
<element name="COARno" field="COARno" />
<element name="NominalAccountNo" field="NominalAccountNo" />
<element name="Description" field="Description" />
<element name="Natureofaccount" field="Expression" />
<element name="TotalAmount" field="Amount" />
</group>
</group>
<group name="SQL161" sql="SELECT 
FTR,ID, Amount, BusinessDate, COARno, Description, Expression, NominalAccountNo, OBJVersion
FROM ProjekCin.LSL WHERE BusinessDate = '20150602'" excelSheetName="2">
<group name="g1">
<element name="No" field="FTR" />
<element name="COARno" field="COARno" />
<element name="NominalAccountNo" field="NominalAccountNo" />
<element name="Description" field="Description" />
<element name="Natureofaccount" field="Expression" />
<element name="TotalAmount" field="Amount" />
</group>
</group>
<group name="SQL161" sql="SELECT 
FTR,ID, Amount, BusinessDate, COARno, Description, Expression, NominalAccountNo, OBJVersion
FROM ProjekCin.LSL WHERE BusinessDate = '20150602'" excelSheetName="Selection">
<group name="Selec">
<element name="sql" field="sql" />
</group>
</group>
</report>
}

/// This XML defines the display for this report.
/// This is used to generate the XSLT stylesheets for both HTML and XSL-FO.
XData ReportDisplay [ XMLNamespace = "http://www.intersystems.com/zen/report/display" ]
{
<report xmlns="http://www.intersystems.com/zen/report/display"
 name="report" title="Tutorial">
<!-- Optional Init element inserts custom XSLT instructions at the top level of the generated XSLT stylesheet. 
<init ></init>-->
<!-- Optional Document element specifies page layout and style characteristics.--> 
<document width="8.5in" height="11in" marginLeft="1.25in" marginRight="1.25in" marginTop="1.0in" marginBottom="1.0in" ></document>
<!-- Optional Pageheader element. 
<pageheader ></pageheader>-->
<!-- Optional Pagefooter element. Does not apply in HTML output. 
<pagefooter ></pagefooter>-->
<!-- Required Body element. -->
<!--<body>
 add display definition of the report here. -->
 <!-- <table group="ProjekCin/cin" 
   excelSheetName="Cinema" >
    <item field="ID"/>
    <item field="FilmShowing"/>
    <item field="NrOfSeats" isExcelNumber="true"/> 
    
   </table>
  
</body>-->
</report>
}

}

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?

A quick announcement about the upcoming Global Summit 2016 -  April 10-13, 2016.

InterSystems Global Summit 2016 is an unparalleled opportunity to meet with your peers and with InterSystems’ executives and experts, discussing the technologies, strategies, and methodologies that lead to success.

All InterSystems Global Summit 2016 sessions will be held at the Arizona Biltmore in Phoenix, Arizona on April 10-13, 2016

Learn more about Global Summit 2016 and register today!

(Early bird discounts end soon!)

hi ,

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

 Thanks,

sansa.

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 ..myProp = 32
	
	// code from the CODE post
	set property = $PROPERTY($THIS, "myProp")
	
	// extra code to help test
	write property
}

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

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.