Caché

Rule to validate SQL syntaxis

Coding Guidelines, Development Environment, SQL, Caché, InterSystems IRIS

Hi! We have received a request to create a new rule on CachéQuality to identify when a developer uses double quotes (" ") within any SQL statement.

We have been asked many times about SQL validation rules, and we would like to open a debate to allow everyone discuss what would you like to be checked on a SQL statement.

Current examples are for basic situations:

Using SQL.Statement class:

Set stmt = ##CLASS(%SQL.Statement).%New() Set query = "Select Val1, Val2 FROM Table WHERE Val1=""SomeCondition"""

Using embedded SQL

&SQL(SELECT Val1, Val2 INTO :val1, :val2 FROM Table WHERE Val1="SomeCondition")

Post by Daniel Tamajon 19 March 2019

Last answer 1 April 2019 Last comment 28 March 2019

0 0 3

answers

comments

146

views

rating

How to write the home address right?

Beginner, Data Model, Languages, Mapping, Object Data Model, ObjectScript, XML, Caché, InterSystems IRIS

How Tax Service, OpenStreetMap, and InterSystems IRIS
could help developers get clean addresses

Pieter Brueghel the Younger, Paying the Tax (The Tax Collector), 1640

In my previous article, we just skimmed the surface of objects. Let's continue our reconnaissance. Today's topic is a tough one. It's not quite BIG DATA, but it's still the data not easy to work with: we're talking about fairly large amounts of data. It won't all fit into RAM at once, and some of it won't even fit on the drive (not due to lack of space, but because there's a lot of junk). The name of our subject is FIAS DB: the Federal Information Address System database - the databases of addresses in Russia. The archive is 5.5 GB. And it's a compressed XML file. After extraction, it will be a full 53 GB (set aside 110 GB for extraction). And when you start to parse and convert it, that 110 GB won't be enough. There won't be enough RAM either.

Post by Dmitrii Kuznetsov 31 March 2019

+ 2 2 1

comments

108

views

+ 2

rating

Bash script to create csv files for every global contained in a %GOGEN exported file from Cache

Code snippet, Caché

Hello

I made for fun a bash script that creates csv files from a %GOGEN exported file.
%GOGEN, the utility for exporting globals for Cache 5.xx

First I thought it would be very simply with bash, but ...
- if I want a header in the csv file
- if you export with GOGEN more globals together not only one
- if I want a csv file for every global/indexes has the global ..

The simply bash script goes up 100 lines of code. If I will start again with this, I would use Python or Go, not bash.

Example:

For a EXPORTED.GLO fil

Post by Julio Francisco 31 March 2019

0 0 1

comments

views

rating

Studio debugger since 2018.1.1

Debugging, Studio, Caché

Hello,

Last weekend we've updated our Caché version to

Versie:

Cache for Windows (x86-64) 2018.1.1 (Build 312U)

I'm using Studio to develop. I've been using the built-in debugger and it has been working nicely. But now, since the upgrade, I'm getting this error when trying to debug any routine or class method:

Executing ##class(Blue.App.Handler.Adsolut).TestConnection()
<COMMAND>zDebugStub+30^%Debugger.System.1

This is the code for the classmethod I got the error on

Post by Rueben Van Mol 14 March 2019

Last answer 14 March 2019 Last comment 30 March 2019

0 0 6

answers

comments

302

views

rating

Announcing Support for Docker Container Technology as a Platform in 2016.1 Release

Caché, Docker, Development Environment, Release

InterSystems is delighted to announce the support of Docker container technology as a platform from the moment 2016.1 will be released.

Docker is a disruptive system technology that has many benefits and offers many advantages for those investing in infrastructure-as-code or immutable-infrastructure provisioning & deployment scenarios.
Like any new technology that appears, there is a learning curve, and many considerations need to occur when using it. However, Docker container technology has already proven to be successful by a huge follow-up with many companies already using it in production. Furthermore & FYI, all public cloud providers already support it.

InterSystems validates and supports its technologies on Docker container engine from v1.8 and above with CentOS, Ubuntu, RedHat and SUSE based containers from the official Docker Hub repository or their respective projects and sites.

Have fun with it

Post by Luca Ravazzolo 27 January 2016

Last comment 29 March 2019

+ 5 0 9

comments

1815

views

+ 5

rating

Multiple file uploads from a csp

Caché, Ensemble

I want to upload several files using the html tag

< input multiple="multiple" name="BulkFileUpload" type="file">

. The upload.csp page in the SAMPLE namespace only shows how to extract a single file from the MimeData on the %request object. I cannot fathom how to extract multiple files from the MimeData in the %request object in cache. Can some kind soul explain to me how to do that?

Post by Dave Kilburn 29 March 2019

Last answer 29 March 2019 Last comment 29 March 2019

0 0 2

answers

comments

views

rating

Problem starting production

Development Environment, Management Portal, Studio, Caché, Ensemble, HealthShare

Hope someone can help me, so i was developing a script and during the tests I was using the csession to execute a method. Also i thought i had to stop the instance i was using, so I used the ccontrol stop [instanceName] to stop the instance, but when i restarted the instance i got this error trying to start my production, I have an idea of what's the problem but i don't know how to fix it.

ERRO <Ens>ErrException: <FILEFULL>zStartProduction+62^Ens.Director.1 ^Ens.Runtime("Name"),/hs-connect-hom/db/BPINTEGRADEV-GLB/ -- - registrado no log como '-' número - @' Set ^Ens.Runtime("Name")=pProductionName'

Post by Rodrigo Souza 28 March 2019

Last answer 29 March 2019 Last comment 29 March 2019

0 0 3

answers

comments

views

rating

ObjectScript error handling snippets

Code snippet, ObjectScript, Caché

ObjectScript has at least three ways of handling errors (status codes, exceptions, SQLCODE, etc.). Most of the system code uses statuses but exceptions are easier to handle for a number of reasons. Working with legacy code you spend some time translating between the different techniques. I use these snippets a lot for reference. Hopefully they're useful to others as well.

�

Post by Pravin Barton 28 March 2019

Last comment 29 March 2019

+ 11 7 3

comments

136

views

+ 11

rating

Task Manager Stopped

Development Environment, Management Portal, System Administration, Caché, Ensemble, HealthShare, InterSystems IRIS

So i'm having this problem with the task manager, the tasks simply stopped running. I had a problem with queued massages and trying to figure out what to do i'm afraid I may messed up something else, can someone help me ?

Post by Rodrigo Souza 26 March 2019

Last comment 28 March 2019

0 0 2

answers

comments

views

rating

Subclasses and/or Inheritence

Beginner, Data Model, Object Data Model, Caché

First time post, also a new Cache developer, hence the <Beginner> tag.

If our data has Predefined terms in a dictionary, and a user can add terms on their own, can the terms exist in different tables?

Lets call the tables "Terms" and the user data in "UserTerms".

If a third class definition has a property of "Term" can it not be either Terms or UserTerms?

I'm leaning towards using a Subclass strategy where the pseudo "Parent" (forgive me) is Dictionary.Term and the child is along the lines of Dictionary.Term.User

Dictionary.Term.User can inherit from Dictionary.Term and this is stated in the Docs "If class B inherits from class A, you can use an instance of class B in any location where you can use an instance of class A."

This applies to properties of a class correct? Not just methods

Post by Steve Hayworth 25 March 2019

Last answer 26 March 2019 Last comment 28 March 2019

0 0 3

answers

comments

views

rating

Internal Structure of Caché Database Blocks, Part 1

Caché, Databases, System Administration

InterSystems Caché globals provide very convenient features for developers. But why are globals so fast and efficient?

Theory

Basically, the Caché database is a catalog having the same name as the database and containing the CACHE.DAT file. On Unix systems, the database can also be an ordinary disk partition

Post by Dmitry Maslennikov 3 October 2016

Last comment 27 March 2019

+ 8 3 9

comments

2372

views

+ 8

rating

How to unpack rar archive

ObjectScript, Caché

Hello,

How I can unpack rar archive with 7z program in COS?

Post by Token Ibragimov 11 February 2019

Last answer 12 February 2019 Last comment 27 March 2019

0 0 1

answers

comments

119

views

rating

Importing routine in WIndows 2016 server giving write error

Caché

Hi,

We recently moved our cache instance from windows 2012 to windows 2016 and when i try to now import % routines i'm getting the following error "Unable to obtain a write lock on this routine because either another user has the routine open for editing or you do not have write access to the database the routine is stored in. This item will be skipped."

This is a fresh installation of cache and I've moved the cache.dat and csp pages across. It seems to work fine but can't import % routines which I need.

Has anyone experienced this and can help?

Thanks

Post by Alice Shrestha 26 March 2019

Last answer 26 March 2019 Last comment 27 March 2019

0 0 2

answers

comments

views

rating

Iterating Ens.Request to create a JSON

Caché, Ensemble

Let's say we have a class

AbcRequest extends Ens.Request, PropertiesBaseAbstractClass(has all my properties common to all request)

Prop1

Prop2 and so on

Now in my Business Operation

I want to make a json dynamically from this request.

Yes obviously I can do is

Set requestDefinition = ##class(%Library.CompiledClass).%OpenId("MyCreateRequest")
Set JsonObject = ##class(%DynamicObject).%New()

       for i=1:1:requestDefinition.Properties.Count() {
           Set key           = requestDefinition.Properties.GetAt(i).Name
           Set value       = $property(pRequest,requestDefinition.Properties.GetAt(i).Name)
           Set JsonObject.key = value

       }
       Set requestString       = JsonObject.%ToJSON()

This makes a json {"key":""}

Post by Neerav Verma 26 March 2019

Last answer 26 March 2019 Last comment 26 March 2019

0 0 3

answers

comments

views

rating

Network access on Windows Host file commands

Caché

Good morning

I'm probably overlooking something very basic, but I'm running on Win2016 with Cache 2016.2 - All the work I am doing is in INT routines, but I'm making some calls to the Host File system using $ZF(-1).

I have a few mapped Network drives that are mapped in Windows, typically these are locations where I want to back up some files.

My process is quite simple:

1. Read data

2. Zip data files using RAR

3. Create folder on Network drive

4. Move RAR files to new network share.

I've tried a few different commands:

S LOC="G:\RAN\Backup1\",CMD="MD "_LOC,X=$ZF(-1,CMD)

S LOC="\\data1\data\RAN\Backup1\",CMD="MD "_LOC,X=$ZF(-1,CMD)

I'm unsure if its a limitation of Cache to do this sort of thing, or if I should created a BAT file and then kick off a Windows call to run the BAT file

Post by Richard Newberry 26 March 2019

Last answer 26 March 2019 Last comment 26 March 2019

+ 1 1 4

answers

comments

views

+ 1

rating

InterSystems Partnertag Österreich 2019

InterSystems IRIS Experience, Caché, Ensemble, InterSystems IRIS, InterSystems IRIS for Health

Save the date ! 14. Mai 2019

Location: as in the last years Hilton Garden Inn South Vienna, Wien.

I hope to meet you all there. :-)

Post by Robert Cemper 20 March 2019

Last comment 26 March 2019

+ 7 0 1

comments

109

views

+ 7

rating

Querying many-to-many relationship objects , dynamic arrays and JSON

Databases, JSON, SQL, Caché

I have two classes

Post by Giray Ozel 25 March 2019

Last answer 25 March 2019 Last comment 25 March 2019

0 0 2

answers

comments

views

rating

InterSystems Cache with Laravel (Eloquent) using ODBC

ODBC, Web Development, Caché

Hi Community

I have created a simple package that allows the use of Cache with the Laravel Framework.

From my initial testing everything seems to be operating smoothly but I would like to appeal to the PHP users in the community to help me improve this package.

For those of you out there who have time and would be interested in this, please visit the repo at https://github.com/jeandormehl/laracache

Thanks in advance

Post by Jean Dormehl 6 December 2018

Last comment 25 March 2019

+ 4 2 3

comments

178

views

+ 4

rating

How to create dynamical links in csp

Application Server, Beginner, CSP, Caché

I have an application using examples from the lottery example in samples name space how do I create a dynamically link based on the data displayed to add a record id to the link

the idea is to loop over the records displays fields and link to edit the shown data at the end of the record in a table format

Post by Thembelani Mlalazi 25 March 2019

Last answer 25 March 2019

0 0 2

answers

comments

views

rating

A Tutorial On WebSockets

JavaScript, Node.js, ObjectScript, Tutorial, Web Development, Caché, InterSystems IRIS, Open Exchange

Intro

Most server-client communication on the web is based on a request and response structure. The client sends a request to the server and the server responds to this request. The WebSocket protocol provides a two-way channel of communication between a server and client, allowing servers to send messages to clients without first receiving a request. For more information on the WebSocket protocol and its implementation in InterSystems IRIS, see the links below.

This tutorial is an update of "Asynchronous Websockets -- a quick tutorial" for Caché 2016.2+ and InterSystems IRIS 2018.1+

Post by Lily Taub 19 March 2019

Last comment 22 March 2019

+ 4 2 3

comments

262

views

+ 4

rating

Querying ODBC SQL Server

Caché, ODBC, SQL, Ensemble

Hi I've got a service setup to query a sql server via ODBC.

I've got all the parameters etc setup and everything is ok

My Query i

Post by Richard Housham 16 July 2018

Last comment 22 March 2019

0 1 3

answers

comments

462

views

rating

Adopted Bitmaps example now on Open Exchange

Globals, Indexing, Performance, SQL, Caché, Ensemble, InterSystems IRIS, Open Exchange

In my earlier article on Adopting Bitmaps I described the technique already.
Now you can find a code example also on Open Exchange.

Post by Robert Cemper 22 March 2019

+ 7 1 0

comments

views

+ 7

rating

Change passwords w/o going to web portal

Admin, Code snippet, Deployment, Microsoft Windows, Microsoft Windows Server, System Administration, Users, Caché

I've seen a few password change posts, but I wasn't 100% sure it was the same process, so I am asking here. We periodically have to change the passwords for a few Cache user accounts across several servers. Is there a process/script to change these passwords without having to go into the web portal on each server? Thanks so much, and I apologize if this was covered in some of the other articles that I've run across. Just looking for the best method.

Post by James Davidson 20 March 2019

Last answer 20 March 2019 Last comment 21 March 2019

0 0 2

answers

comments

views

rating

How to find the XPATH of original CCDA xml element from SDA3 object

HL7, Mapping, XML, Caché, Ensemble, HealthShare, InterSystems IRIS for Health

We can load a CCDA xml document into SDA3 object.

Once parsing SDA3 object, how do we determine from which XPATH from CCDA the specific SDA3 elements were mapped to.

Is there any way?

Post by Bachhar Tirthankar 20 March 2019

Last answer 21 March 2019

0 0 2

answers

comments

views

rating

Statistical Functions in Cache

Caché

Hello,

Is there a way to implement Excel SLOPE and INTERCEPT statistical functions in Cache? Any help would be greatly appreciated.

Alex.

Post by Alexander Grishkan 12 February 2019

Last answer 21 March 2019

0 0 2

answers

comments

113

views

rating

String to date

CSP, Databases, SQL, Caché

I am trying to convert a string to date but can not get it to work I have function that I would like to take in a date string and covert it to date object

here is the ezample so far can not get it to work any help appreciated

set p="12/03/2019"
 
w $System.SQL.TODATE(p,"YYYY-MM-DD")
 
<ILLEGAL VALUE>todate+32^%qarfunc

if I try this still get the wrong value returned

set p="12/03/2019" 
w $ZDATE(p,3)
1841-01-12

Post by Thembelani Mlalazi 12 March 2019

Last answer 21 March 2019 Last comment 12 March 2019

0 0 6

answers

comments

206

views

rating

Light weight EXCEL download

Caché

I worked through the Community for proposals to provide end users
in an easy way with data formatted as EXCEL sheet.

There is an great article Tips & Tricks - SQL to Excel

there's an important message embedded: "EXCEL can interpret HTML tables and display them as usual"

Nice!
But the result is on your server and you are left alone to get it out to your remote user somewhere.
Could be a subject to be solved using REST or WebServices

Post by Robert Cemper 22 August 2017

Last comment 20 March 2019

+ 13 0 10

comments

646

views

+ 13

rating

InterSystems DACH Symposium 2019

Big Data Experience, InterSystems IRIS Experience, Caché, Ensemble, InterSystems IRIS

Save the date!

Save the Date InterSystems DACH Symposium 2019

Just in case this hasn't reached you (or your manager didn't pass it to you )

https://www.intersystems.com/de/news-events/events/veranstaltung/intersystems-dach-symposium-2019/

Post by Robert Cemper 20 March 2019

Last comment 20 March 2019

+ 6 0 0

comments

views

+ 6

rating

Cache docker image

Docker, Caché

Hello all,

I am having some issues creating a docker image with a fresh cache installation. The error that I am getting right now is that gzip is required for a cache installation, but was not found in my system. Even though, this is shown as installed in the base centos 7 image. My host machine is Windows 10 using the latest docker version.

Here is my dockerfile, its simple:

FROM centos:latest

RUN yum update -y && yum -y upgrade

COPY ./cache-2017.1.3.317.0.18571-lnxrhx64.tar.gz .

RUN tar -zxf cache-2017.1.3.317.0.18571-lnxrhx64.tar.gz

RUN ISC_PACKAGE_INSTANCENAME="MyDatabase" \

          ISC_PACKAGE_INSTALLDIR="/usr/cachesys/" \

          ISC_PACKAGE_UNICODE="Y" \

         ISC_PACKAGE_CLIENT_COMPONENTS="" \

         ISC_PACKAGE_INITIAL_SECURITY="Minimal" \

        /cache-2017.1.3.317.0.18571-lnxrhx64/cinstall_silent



EXPOSE 57772 22 1972

ENTRYPOINT ["ccontrol", "start cache"]

�

Post by John Peeke 19 March 2019

Last answer 20 March 2019 Last comment 20 March 2019

0 0 3

answers

comments

104

views

rating

AWS API calls

REST API, Caché

This question is about calling AWS REST APIs. Based on:

http://docs.aws.amazon.com/general/latest/gr/sigv4_signing.html

AWS requires REST clients to call their APIs using Signature Version 4 which in case you don't know what I am talking about is a pain in the neck. Here comes the question:

Has anybody, by any chance implemented the v4 signing alg. in COS? If yes, would she or he have the kind heart to share?

Thanks,

Chris

Post by Chris Paraskiv 20 March 2017

Last answer 23 March 2017 Last comment 19 March 2019

0 0 4

answers

comments

273

views

rating

Description

How Tax Service, OpenStreetMap, and InterSystems IRIScould help developers get clean addresses

Theory

Intro

How Tax Service, OpenStreetMap, and InterSystems IRIS
could help developers get clean addresses