Caché | InterSystems Developer Community

Question

Eduard Lebedyuk · Oct 30, 2017

Zstrip to clean string

I'm extracting text from HTML (more on how - here), and after I extract text it has two problems:

Lot's of $c(10) control characters
Multiple whitespaces

Here's an example of the text extracted from HTML page:

#Beginner #Caché #ObjectScript

0 2

0 1.6K

Article

Sergey Mikhailenko · Jun 2, 2020 8m read

Increasing the Security of the InterSystems IRIS DBMS

When you first start working with InterSystems IRIS, it’s a common practice to install a system with only a minimum level of security. You have to enter passwords fewer times and this makes it easier to work with development services and web applications when you're first getting acquainted. And, sometimes, minimal security is more convenient for deploying a developed project or solution.
And yet there comes a moment when you need to move your project out of development, into an Internet environment that’s very likely hostile, and it needs to be tested with the maximum security settings (that is, completely locked down) before being deployed to production. And that’s what we’ll discuss in this article.
For more complete coverage of DBMS security issues in InterSystems Caché, Ensemble, and IRIS, you may want to read my other article, Recommendations on installing the InterSystems Caché DBMS for a production environment.
The security system in InterSystems IRIS is based on the concept of applying different security settings for different categories: users, roles, services, resources, privileges, and applications.

Users can be assigned roles. Users and roles can have privileges on resources — databases, services, and applications — with varying read, write, and use rights. Users and roles can also have SQL privileges on the SQL tables located in databases.

#Beginner #Security #System Administration #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health

Open Exchange app

5 2

2 907

Question

Laura Cavanaugh · Mar 21, 2018

Is there a temporary-password concept in Caché 2016?

I need to offer new users on our system a temporary password that is valid for only 48 hours. This is different than a 60-day password expiration window for existing users' passwords (where a password needs to be changed every 60 days), and is different than a "user expiration date", where you can set a date where the user's account expires and is disabled on that date, and different than the inactivity expiration date where a user becomes active if his account is not used within, say, 30 days.

#Security #Authentication #Caché

0 2

0 429

Question

Nael Nasereldeen · Apr 24, 2018

REST- Cache as the server and the client, problem with PUT method , Length required error

Hi,
Trying to work with REST protocol, using IIS 8, both client and server are Cache servers,
I have the following problem-
When I send a PUT command, I get the following error:
<HTML><HEAD><TITLE>Length Required</TITLE>
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD>
<BODY><h2>Length Required</h2>
<hr><p>HTTP Error 411. The request must be chunked or have a content length.</p>
</BODY></HTML>

#REST API #Caché

0 2

0 900

Question

CJ H · Jul 17, 2018

Programmatically create database and namespace

Is there any COS API to create the database (with designated path) and the namespace ?

Also, the API to attach a given database to a given namespace?

Thanks.

#Object Data Model #Caché

0 2

0 707

Question

Thembelani Mlalazi · Sep 24, 2018

How to use com.intersys.gateway.Service

I am trying to work with Java Selenium through Cache my java programme works fine but I would like to pass parameters to the jar file form my Ensemble production.

#Beginner #Java #Object Data Model #REST API #Caché

0 2

0 530

Question

Thembelani Mlalazi · Jan 15, 2019

Why <UNDEFINED> on SQL

I have an sql statement that I would like to execute but I get the error

"zSearchChanges+5^MergeHyland.TypeTwoUtil.1 *KeyID"

and here is my sq

l  "&sql(SELECT Key INTO :KeyID FROM MergeHyland.TypeTwoDimesionalTable WHERE Key = :Key)" any ideas why

#Databases #SQL #Caché

0 2

0 203

Question

Dhaval Shah · Jan 24, 2019

How to make a XML Message ?

Hi All,

Actually I am trying to implement a RESt API where in I will get ZIPCODE as request and I need to call external API which will take ZIPCODE as input and give State and City in response.

But the problem is the request is in XML Format and also response is in XML format.

Example :

#DTL #Object Data Model #REST API #XML #Caché

0 2

0 606

Question

Neerav Adam Verma · Apr 12, 2019

Method Performance Statistics

Hello All,

There are few tools for SQL optimization available and even query builder has Show Plan to give us an estimation of the resources needed to execute.

For Methods - Is there anything similar ??

I would like to see a similar approach as to the time taken for method to execute.

Is Studio Debugger only option ??

#Caché

0 2

0 281

Question

Jimmy Christian · Apr 23, 2019

SQL CREATE Table Name with System defined variable

Hello all,

I am still learning CACHE and have below question.

In one of my ZEN method i am creating a table using

#SQL #Caché

0 2

0 208

Job

Paul Martin · Jul 24, 2019

Job Opportunity - Cache Developer - Redditch

Opportunities exists for keen Caché developers to join our established software house in Redditch.

#Job Opportunity #Caché

1 2

0 555

Question

Andre Wessels · Dec 5, 2019

How to paste a copied document into a %GlobalBinaryStream from the clipboard.

Good day,

We upload images into the database with this code :

<tr>
<td align="right">FileName</td>
<td><input type=file size=200 name=FileStream></td>
</tr>

s FullFilename = %request.Get("FileName")
s FileName = ##class(%File).GetFilename(FullFilename)
s ItemImage.FileName = FileName

#Caché

1 2

0 433

Question

Salma Sarwar · Oct 6, 2020

Programmatically define new message and segment without %Clone

I would like to create a new message of a particular type and append various segments programmatically. I have started with the following snippet. What I am currently finding difficult is to define a segment of a particular segment structure. I would like to append a pid segment of 2.3.1 to my message. I know I could you the importfromstring but I wanted to know whether there was a better way of achieving this.

#Code Snippet #HL7 #Caché #HealthShare

0 2

0 546

Question

John Lisa · Oct 30, 2020

IDX GE Centricity Best strategy for huge extraction

I'm looking for the best strategy for extracting data from a Cache table that houses 86 Million lines of data and around 190 columns. I'm currently using DBeaver and the Invoice Service dates go back to 1996. Optimistically I'm looking to pull to a pipe delimited flat file, but even a year's worth of data takes many hours to get query results.

Any suggestions for the best practice/strategy?

Thanks,

John

#Caché

0 2

0 316

Question

Lucas Soares · Jan 26, 2021

How to use Node.js with cache

Hello everyone!

I'm new with cache and I wold like to know if I can integrate cache with node.js and how I can do this?

#Caché

0 2

0 193

Job

Helberth Soares · Jun 12, 2021

Looking for consultant - job opportunity

Hi everyone,

I am talking from Brazil and we have one very important customer that requested our support to find a consultant, deeply specialized in Cache that could work with us attending this customer. It has a tons of data and its core application is based on Cache.

If you are interested send me an email with the subject title - Cache consultant opportunity - and we will make contact with you. The main request is how strong are your skills in cache and it would be considered a differentiator if you are a portuguese speaker.

Regards - Helberth Cavalcante.

#Databases #Job Wanted #Caché #Job Opportunity

3 2

0 290

Question

Rochdi Badis · Jun 27, 2021

Call client method %OnAfterCreate page

Hi Guys,

how can I call a client method inside %OnAfterCreate method?

thanks

#Caché

0 2

0 129

Question

Kevin McGinn · Sep 9, 2021

Usage of the DatabasesByServer method of the Config.Databases class

I am trying to get a list of databases using the DatabaseByServer method but I am only getting an empty string. I have not found any useful examples of the proper usage of this class/method.

I have tried 2 formats. First

set dbList=""

set db=##class(Config.Databases).DatabasesByServer("my-host",.dbList)

I also tried:

set db=##class(Config.Databases).DatabasesByServer("my-host",.dbList,"/cachesys/")

In each case dbList is empty string. I can not figure out what I am missing.

#Caché

0 2

0 95

Question

Josh Barney · Nov 4, 2021

MVBASIC Undimensioned array question

When using an undimensioned array is there a way to write the array to a file? Something like this

DIM C()
C('TEST') = 2
C('WEST') = 5
C('BEST') = 1
WRITE C on myfile, 1

#Caché

0 2

0 186

Question

J Ness · Feb 8, 2022

User trying to access CACHE and getting error message

#Caché

0 2

0 266

Question

Smythe Smythee · Apr 13, 2022

How to Create a New segment in a ADT^A01

Hi Team,

I am working on data transformation ADT^A01 from ADT^A01 ,In both source and target MRG segment is not available. How can i create a new MRG segment in Target. Kindly share your ideas how to create a new segment in Data transformation.

Thanks in advance

#Caché #Ensemble

0 2

0 289

Question

Nilson Cupertino · May 10, 2022

ERROR CONNECTION CACHE WITH .NET 6

Hello,

I have an error connecting the InterSystems cache with the odbc driver with the ODBC-2017.2.2.865.0-lnxrhx64.tar version using the ubuntu versions 20.04 and version 18.04 (which works with the .Net Core 3.1 version) with the Net 6.

Error:

#.NET #ODBC #Caché

0 2

0 281

Question

Yone Moreno · Aug 12, 2022

Efficient regular expression to detect 3 attributes in URL

Hello community,

First of all thanks for your time reading and answering this post:

We have read the following topics:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

https://community.intersystems.com/post/using-regular-expressions-cach%C...

#Code Snippet #Caché

0 2

0 205

Question

William Glover · Nov 1, 2022

How to get the list of values in the productions category dropdown menu in code

How can I retrive the values present in the Category dropdown at the top of the production in code?

#Caché #HealthShare

0 2

0 210

Question

Smythe Smythee · Nov 16, 2022

How to get values from a serialobject class

Hi,

want to get the values from a serial property because my code depends upon the class serial class.

For example

Serial class

Class Data.Serial Extends %SerialObject

{

Property FirstName as %String;

Property LastName as %String;

}

Persistent class

#Beginner #Object Data Model #ObjectScript #SQL #Caché #Ensemble

0 2

0 467

Question

Virat Sharma · Jan 11, 2023

Error while running the SQL Query- Incorrect list format: 0 >= 0_SQLSTATE: S1000

Hello Team,

I need a help in the following error I am getting while running the SQL Query. I am running the SQL Query from different table using inner join. I run this everyday for last 90 days but for few days while extracting the data through this query I am getting this error. Please assist.

SQLException was thrown: Incorrect list format: 0 >= 0_SQLSTATE: S1000

Error getting attributeColumn: Name

Error getting attributeColumn: Amount

#SQL #Caché #InterSystems IRIS

0 2

0 320

Article

Hiroshi Sato · May 25, 2023 2m read

API to import/export routines

This is an article on the InterSystems FAQ site.

1. Export API

a. Use $system.OBJ.Export() to specify individual routines to export. For example:

do $system.OBJ.Export("TEST1.mac,TEST2.mac","c:\temp\routines.xml",,.errors)

The format to specify is routine name.extension, and the extension is mac, bas, int, inc, obj.

Errors during export are stored in errors.

#Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health

7 2

2 383

Question

Pravin Barton · Jan 20, 2016

Use an array as a SQL parameter for a Zen tablepane?

I'd like to have an array as a parameter for a SQL 'WHERE... IN' statement. The array would be modified in javascript on the browser. Here's a simplified example:

#SQL #Frontend #ZEN #Caché

1 2

0 423

Article

Bill McCormick · Feb 19, 2016 4m read

Why Atelier? And what about Studio?

I have been meaning to make a post about this topic for a few weeks and the other day an issue came in through the WRC about it so it seems this is a conversation we should be having. I want to begin by taking a few moments to explain "Why Atelier" then we can talk about what this means in the general sense for Studio and Atelier and Caché developers. We have wrestled with what to do with Studio for years. When I moved to Product Management in 2008 this was already a "thing". At the time we could not reach a consensus. Some felt Studio was fine as is.

#Caché #Development Environment #Ensemble

9 2

0 3.6K

Question

Rahul Raj · Apr 18

Request for ISCAgent setup download

Hi! I am planning to move my Arbiter from a Unix server to a container(again on linux). To do this, I need the ISCAgent tar.gz file to configure Arbiter for our mirrored servers. I have tried searching for it on the Intersystems help forums but couldn't find it. Is it possible for someone to redirect me to the correct website to download it?

Thank you in advance!!

#Mirroring #Caché #Ensemble

0 2

0 50