#Caché

Post a job Follow
30 Followers · 4.6K Posts

  

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

Documentation.

Post a job Follow
Question Seppo Kruth · Oct 25, 2018

CSP Gateway with Apache 2.4 on a remote computer

I'm trying to set up a  webserver (Apache 2.4 on Windows 10) for a CSP application on a Cache which is not running on the same Computer. 

My Problem is that in the csp-pages there is a declaration:

<link rel="stylesheet" type="text/css" href="/jbsscan/stylesheets/style.css"></link>
<script language="JavaScript" type="text/javascript" src="/jbsscan/javascript/javascriptScanner.js"></script>
 

When I access the csp pages the stylesheet and javascript file are missing, in the http trace of the csp gateway I see that there is a 404 for these files.

#Caché #CSP
5
0 685
Article Gevorg Arutiunian · Oct 26, 2018 1m read

Send an HTML Email

This code snippet contains the class method "test" which sends an HTML email. Change the literal strings in the method to customize the email's from address, to address, subject, and body:


Class objectscript.sendEmail Extends %RegisteredObject
{
classmethod test() {
set m=##class(%Net.MailMessage).%New()
set m.From="user@company.com"

	set m.IsHTML=1
	 
	do m.To.Insert("user@company.com")
	set m.Subject="Sent by IRIS mail"
	set m.Charset="iso-8859-1"
	do m.TextData.Write("&lt;HTML&gt;&lt;HEAD&gt;&lt;TITLE&gt;&lt;/TITLE&gt;"_$char(13,10))
	do m.TextData.Write("&lt;META http-equiv=Content-Type content=""text/html; charset=iso-8859-2""&gt;&lt;/HEAD&gt;"_$char(13,10))
	do m.TextData.Write("&lt;BODY&gt;&lt;FONT face=Arial size=2&gt;Test &lt;B&gt;Test&lt;/B&gt;&lt;/FONT&gt;&lt;/BODY&gt;&lt;/HTML&gt;")
	set s=##class(%Net.SMTP).%New()
	set s.smtpserver="mail.company.com"
	set status=s.Send(m)
}



}

Here's a link to the code on GitHub

#Caché #Code Snippet #InterSystems IRIS #ObjectScript #Caché
0
1 1311
Question Anne Kantola · Jun 29, 2018

Error with set parObj = {}.%FromJSON(%request.Content.ReadLineIntoStream())

I try to test our REST/JSON (POST) services,where queryparametres are in content as json and the answer in contet is also as json.

This is my testClient:

Class XXX.RESTClient Extends %RegisteredObject
{
ClassMethod TestXXX()
{
#dim tRequest As %Net.HttpRequest = ##class(%Net.HttpRequest).%New()
set tRequest.ContentType="application/json"
s json=##class(%ZEN.proxyObject).%New()
s json.x="XXX" 
d ##class(%ZEN.Auxiliary.jsonProvider).%WriteJSONStreamFromObject(.jsonStream,json)
set jsonText=jsonStream.Read(jsonStream.Size)
set tSC=tRequest.EntityBody.Write(jsonText)
set tSC = tRequest.

#Caché #Beginner #JSON #REST API
5
0 2334
Article Vasiliy Bondar · Oct 14, 2018 4m read

Configuring LDAP authentication in InterSystems Caché using Microsoft Active Directory

From the first glance, the task of configuring LDAP authentication in Caché is not hard at all – the manual describes this process in just 6 paragraphs. On the other hand, if the LDAP server uses Microsoft Active Directory, there a few non-evident things that need to be configured on the LDAP server side. Those who don’t do anything like that on a regular basis may get lost in Caché settings. In this article, we will describe the step-by-step process of setting up LDAP authentication and cover the diagnostic methods that can be used if something doesn’t work as expected.

#Caché #LDAP #Microsoft Windows Server #System Administration
3
2 2452
Job Simcha Gershon · Oct 20, 2018

Looking for work

Hi every body

I hope it's the right place & I'm not offending any body.

I'm a veteran Mumps/Cache/Ensemble programmer .  I think my only draw back is my age, although my brain is still young & bubbly.

I'm looking a long time for work without success.

I gathered a lot of knowledge & experience during those long years , developed many projects & i'm ready to do any work only to feel useful.

I'll add my resume, I hope & wish that this post will bring some change as I'm desperate to get some work.

Thank you very much Simcha my email is shiluvg@gmail.

#Caché #CSP #JavaScript #Job Wanted #SQL #ZEN
0
0 531
Question Scott Beeson · Jan 21, 2016

Custom function to retrieve environment?

I want to do some logic based on what environment code is running in. I can't find a built-in function to retrieve this so I'd like to write a custom function. Does anyone know of a command that would get the current environment?

#Caché
9
0 831
Question Scott Beeson · Jan 21, 2016

Not sure why I'm getting this error

Here is the function I'm writing:

/// Returns the participant code based on MSH-4
ClassMethod getParticipant(iSendingFacility As %String) As %String [ Final ]
{
   set a = $PIECE(iSendingFacility,"^",1)
   set b = $PIECE(iSendingFacility,"^",2)
   set sc1 = Lookup("ParticipantCodeMap",a)
   if sc1 = "" {
      set sc1 = Lookup("ParticipantCodeMap",b)
   }
   q sc1
}

For some reason when I try to run it I get the following error:

 set sc1 = Lookup("ParticipantCodeMap",a)

I tried adding the the default parameter in case it's not finding it but it didn't help.  What am I missing?

#Caché
5
0 352
Question Guillaume Lepretre · Oct 18, 2018

Use parameter in Select Component

Hello everyone,

I want to fill data into my select component with sql request and parameter.

I tried to follow this example https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KE… 

I need to call a method because my parameter can be different. I tried something like this but it doesn't work... 

 ClientMethod changeParams() [ = javascript ]

or like this : 

 changeParams() [ = javascript ]

You can see my select here : 

#Caché #SQL #ZEN
2
1 363
Question Tiago Ribeiro · Oct 18, 2018

$match or "?"

Hello all...

Is there two matching patterns in Caché, is there a difference in use one or the other?
Example:

USER>set a = "(1234)"

Using $match.

USER>w $match(a,"\([0-9]{4}\)")

USER>1

Using literal match (sorry if not correctly term expression)

What is different from using one or the other?

The 'a?1"("4n1")"' does this pattern exist only Caché.
Exists performance improvement with use pattern Caché?

#Caché #ObjectScript
2
0 679
Question Sean Connelly · Oct 17, 2018

Indirectly traversing MultiDimensional properties

I can directly order over a MultiDimensional property, e.g.

set key=$order(obj.prop(key))

However I have a generic method that has to use the $property method, if I know the keys then I can just fetch a value with...

set value=$property(obj,"prop","key")

But if I don't know the keys then I am not aware of a solution to do this, e.g.

set key=$order($property(obj,"prop",key))

will not work.

There must be an internal solution as a zw command on obj is able to list all of the keys. I'm wondering if there is a $zu function or other trick that can do this. Any ideas?

Thanks,
Sean.

#Caché #Object Data Model
6
0 637
Article Daniel Kutac · Apr 13, 2017 3m read

Binding a "regular" Cache object to %DynamicObject and vice versa

Recently, a partner company started to develop an Angular client for their Cache application. Together, we decided to leverage the power of Caché dynamic objects to exchange JSON encoded data between client and server parts. However, we realized that currently there is a gap in Cache JSON implementation that prevents simple use of traditional registered and persistent classes to exposed their data with the same ease as with XML. I wrote a small JSON adapter, that does the job and bridgers the gap. It's purpose is simple expose data described by a regular Cache class in a one-to-one fashion to a %DynamicObject. On the other hand, when a serialized JSON data comes in, it can be easily deserialized into dynamic object and subsequently bound to regular class by the newly created adapter.

#Caché #Object Data Model #JSON #Caché
7
1 2308
Question Stephen Wilson · Oct 8, 2018

Can you perform Kills or Sets directly on globals within .NET without ObjectScript classes or generated proxy classes ?

I think I already know the answer to this but I thought I'd ask anyway. So the Node.js adapter allows you to perform operations directly on Globals. Does the InterSystems.Data.CacheClient.dll or InterSystems.CacheExtreme.dll provide a mechanism to access Gobals directly or are you accessing globals via Caché ObjectScript classes?

#Caché #Beginner #Object Data Model
5
0 673
Article Gevorg Arutiunian · Oct 18, 2018 1m read

Pass ? parameters to %ZEN.Auxiliary.jsonSQLProvider

This code snippet uses %ZEN.Auxiliary.jsonSQLProvider. The namespace and string of SQL can be edited for different situations. The class method "test" runs the code:


Class eduardlebedyuk.passQuestionParams
{
classmethod test(pValue = 50) {
s ns = $Namespace
zn "samples"
s tSQL = "SELECT ID, Name FROM Sample.Person WHERE Id > ?"
s tPR = ##class(%ZEN.Auxiliary.jsonSQLProvider).%New()
s tPR.sql = tSQL
s tPR.%Format = "tw"
s tPR.maxRows = 100

    s tParam = ##class(%ZEN.Auxiliary.parameter).%New()
    s tParam.value = pValue
    d tPR.parameters.SetAt(tParam,1)
  
    d tPR.%DrawJSON() 
    //d ##class(%ZEN.Auxiliary.jsonSQLProvider).%WriteJSONFromSQL(,,,,,tPR)  //same thing
    zn ns
}



}

(Originally posted to Intersystems CODE by @Eduard Lebedyuk, 5/13/15)

Here's a link to the code on GitHub

#Caché #Code Snippet #InterSystems IRIS #ObjectScript #Caché
0
0 368
Question Peter Kopp · Oct 17, 2018

SQLGateWay performance.

I have a ZEN page with nine tablepanes. Each tablepane queries a table in the same SQLServer db. I have a single SQLGateWay(odbc) to this SQLServer db. I need to get better performance when I query all nine table at the same time. Would my performance improve if I had nine SQLGateWays(nine odbc configurations/connections), one for each query? I would appreciate any and all suggestions for getting the very best performance when using SQLGateWays. Thank you.

#Caché #SQL #Performance #ZEN
1
0 382
Question David Foard · Oct 17, 2018

Can you use a view in a sub-query?

I have created a view to stage some data in a different format and then want to reference that view in a SQL query from a table that filters the data from the view using a property of the table. 

Example:

select
   MsgId,
   FileName,
   (select
      ReportName
     from
      custom_view
     where
       MsgId = ReportId
    ) as ReportName
from
   main_table

Is this even possible? When I try this, I get an error table not found for the view?

David

#Caché #SQL
1
0 353
Question William Proctor · Sep 27, 2016

question on ExternalFreeze on windows platform --

All responses are appreciated.  I am new to both scripting and CACHE so please bear with me.  I am setting up a nightly backup script for freezing cache then backing it up and then thawing it back out.  Currently when I enter the freeze command I am getting a response of access denied even though my id has %all access.  I've tried passing the userid/password as a parameter in the externalfreeze command and passing it from a file.  I've used my id and lastly I used the _system id in the file.  What ID should I use for this or am I passing it wrong?

sample 1:  .

#Caché #Beginner
17
0 1289
Question Danillo Aquino · Oct 15, 2018

Caché - cinstall_silent.

I would like to know how to choose the "Development" installation type in silent mode.

When performing a normal installation:

Please review the installation options:
------------------------------------------------------------------
Instance name: CACHE
Destination directory: /cache
Cache version to install: 2015.2.1.705.0.17420
Installation type: Development

When I perform a silent install:

Please review the installation options:
------------------------------------------------------------------
Instance name: CACHE
Destination directory: /cache
Cache version to install: 2015.2.1.705.0.

#Caché
3
0 605
Question Bill Asby · May 20, 2016

Cache ODBC installed on Win7, but not listed in Ctrl Panel - ODBC Data Sources

Hi,

I ran the Cache ODBC Driver installer as Administrator on my Windows 7 PC this morning. It completed successfully with o indication of any issues. When I check installed programs and features via Win 7 Control Panel, I see it listed as Intersystems ODBC Driver 1.00.000.

However, when I try to configure the driver via Control Panel - Administrative Tools - Data Sources (ODBC), I cannot find it. The only driver listed under the Drivers Tab is SQL Server.

I am not sure how to proceed.

I appreciate any suggestions.

Thanks,

Bill

#Caché
5
0 1728
Question Anne Kantola · Oct 15, 2018

What kind of convert for password when using Angular and Cache 2017.1?

In our language we have scandic letters like ä (a with two dots on it).

In Angular we use login like this:

let headers = new Headers();

password = Base64.fromBase64(password);

headers.append('Authorization', 'Basic ' + Base64.encode(username + ':' + password));

let options = new RequestOptions({ headers: headers, withCredentials: true });

return this._http.get(_param.baseUrl + this._loginUrl, options)

.map((res: Response) => {

It works, but not with these letters.

#Caché #Angular2 #JavaScript
3
0 466
Question Sabarinathan M · Mar 13, 2018

Sending PDF to Printer using Cache - Windows

Hi All,

I need some help with sending PDF files to printer using cache instead of using third party tools(Adobe, foxit reader, etc..).
Sometime i getting access issue with the exe files.

Can able to send text data to printer using below code.

Set Dev="|PRN|PrinterName"
OPEN Dev:(/DATATYPE="TEXT"):80
USE Dev Write "Test printing",!
CLOSE Dev


Any suggestions on sending PDF to printer?

#Caché #Microsoft Windows #ObjectScript
3
0 1033
Question Vivek Ranjan · Sep 28, 2018

Kill object Vs %Reload()

Method1(){

Set OID1=##class(Table).%OpenId(100)

// do Kill OID

}

&SQL(Update Table Set  Column=88)

Method2(){

Set OID2=##class(Table).%OpenId(100)

// Or do %Reload()

Set OID.Column=99

Do OID.%Save()

}

// Column 1 still holds value as 1

For getting the updated value I should do Kill OID in Method1

#Caché #Coding Guidelines #Object Data Model
4
0 733
Question Anne Kantola · Mar 5, 2018

Angular 4 (2-5), Cache Authentication, Cache2017.1, REST

Hi, 

have you any working example of authentication and services in Angular 4 (2-5) and Cache 2017.1?
We have authentication, but we don't want CacheUsername and CachePassword to be in url (this works), but in header (we have not get this work, Problem 1).
We have REST services and they work with CacheUserName and CachePassword, but we want them work with cookie after authentication is done (we have not get this work, Problem 2).

How to code the client and what all we have to code and set on server?
We've tried last this (asked also WRC /Tomas, but not got the answer).
#Caché #Angular #Angular2 #Authentication #JSON #REST API
10
0 2120
Article Alexey Maslov · Nov 23, 2017 12m read

Where is my global stored?

It's well-known that namespace global mapping helps us to write code independent on database storage details (Caché instance name, directory path). But sometimes we can face problems accessing an unsubscripted global which has subscript level mapping (SLM) defined. Most of such cases are evident and associated with administrative tasks that should be done on database level, but some of them can confuse even an experienced developer. Just to start:

  • We can't export such a global using Caché Block format (a.k.a. GOF).
  • We can't kill such a global.

Maybe you can continue this list.

#Caché #Caché #Code Snippet #Globals #Mapping
8
0 1516
Question Udo Guengerich · Sep 26, 2018

Upgrade from Caché 2013.1.7 (Build 974U) to 2017.2.2 (Build 865U_SU): Any experience/known issues/checklists/hints?

Upgrade of custom application

Dear community,

we are a company located in central Germany working with Intersystems Caché since 2003 (Jesus, that's actually a long time in IT).

As we struggle to keep pace with outside development we still operate on Caché 2013.1 surprise

We are, of course, aware that we need to upgrade Caché and therefor plan an upgrade to 2017.2.

Now my question to you bold ObjectScript warriors:

  • Did anyone do this with a legacy application (still have macro routines, the old style)?
  • Has anyone experienced any bigger issues with a move like this?
#Caché #Release
4
0 519