Hi Community, 

Get a first look at InterSystems HealthShare's next-generation healthcare decision support and notification capabilities:

⏯ Introducing InterSystems HealthShare Extended Decision Support

It's time to announce the Winners for February! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in February:

🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

🥈 @Eduard Lebedyuk, Sales Engineer, InterSystems Corporation, Russia

🥉 @Benjamin De Boe, Product Manager, InterSystems Corporation, Belgium
 

 Learn more about the competition and our awesome winners below.

I'm new to cache, come from an oracle and sql server background. In oracle and sql server I could write basically a stored procedure like script and pass it in as text to the command to execute. 

Example:

Below would be the _sqltext

DECLARE @Id INT;

select id into @Id from something;

 if @Id = 9 

BEGIN

do something

END

The _sqltext would work in sql server, what would be the equivalent for cache for it work?

I get a generic error when I try it with cache

using (var mdscmd = new CacheCommand(_sqlText, MyConnection) { CommandType = CommandType.Text }) {

}

Thanks

Business services are powerful components that pull data in from external sources. In most cases, pre-built components do the job, but sometimes you need to code custom business services. There are a few best practices to keep in mind when doing this:

1. Lean and Mean - Business services should be coded to have minimal processing. This is due to the fact that if any errors occur within the business service, no message will be sent, and thus no trace will be created. This makes it very difficult to troubleshoot.

I want to be able to view generated items from visual studio code. In Studio there was an option in the open dialog:

Specifically, I added a namespace to my workspace for editing (Using InterSystems Server Manager) and I want to be able to access the generated items in this namespace.

The Documentation team in InterSystems Learning Services is happy to announce the new InterSystems IRIS Server Migration Guide!

Have you ever wanted to copy, move, or clone an instance of InterSystems IRIS to a new server? Maybe the operating system on the old server is no longer supported, or maybe you want to add a new member to an existing mirror. Migrating your application databases is easy, but what about your tasks, users, roles, resources, and other security settings? What do you need to migrate, and how best to do it?

We have an implementation with a bunch of users, and a bunch of namespaces, both of which are added and removed frequently, and the users have restrictive perms in the namespaces (lets just say, not %All)... and the users are utilizing the VSCODE extension for development.

Per the instructions and the user experience, we need to run:

GRANT EXECUTE ON %Library.RoutineMgr_StudioOpenDialog TO ${user}

For ... each Namespace, and additionally %SYS for Web Apps.

Is there a way to globally just make this happen "once" somewhere or is it absolutely necessary find a spot to

Calling  InterSystems.XEP.Event.Store(object[]) issues an unnecessary debug console line "Elapsed server write time:..." which is polluting the console window.
Traced it to a IRIS.xepSSNDFinish

Is there any way this can be disabled?

Thanks!

Hi Developers,

We are carefully preparing our first 🏆 InterSystems Technical Article Contests in Portuguese 🏆.

As the contest will be officially launched next week, take advantage of this week to choose your topic or, if you are new to InterSystems technology, take the opportunity to learn a little more about the technology in this period to be able to participate!

Good Afternoon My InterSystems IRIS Peers,

I have the following issue that I need help with, I tried all possibilities that I know of, therefore I am reaching out to the community for some insight.

I have a SFTP service that pulling 2.5.1 DFT HL7 messages from our SFTP file server. The issue is that IRIS is transforming patients names and addresses that contain special chars UTF-8 to ANSI.

Examples:

è = è
é = é
í = í-  .......etc

I would like to know if there is a possibility to transform the RAW HL7 before IRIS do its magic or

I have a python script that is pulling the cache instance key expiration date ( KeyExpirationDate() ) which comes back as an integer. With the queryscript function - $ZDATE(73284) I can derive the actual expiration date. Is there a manner or method of creating an equivalent Python script that will convert the integer return by the KeyExpirationDate()  method into a date string?

Hello,

Can anyone help on the below point? It will very helpful for me.

Copy exact same data from IRIS Instance 2019.1 to IRIS 2021.1 with the Identity column from the IRIS database.

Thanks,

Harshdeep Acharya

Can an IRIS RESTful api implement mutual authentication?

If so, can you point me to the documentation.

Thanks

Does any one could tell me how can I access the target properties from inside SQL in DTL Subtransform? For example, if I use the following statement:

SELECT ID INTO :target.SetIDPID  FROM firstlook.person WHERE  FirstName = 'Paul' - as said in documentation :

  SELECT Name INTO :target.Name FROM MainFrame.EmployeeRecord WHERE SSN = :source.SSN AND City = :source.Home.City

I get an Error: ERROR <Ens>ErrException: <PROPERTY DOES NOT EXIST>

But if I pass the value for a variable "SetIDPID" I can use it in a set action without any problem: 

SELECT ID INTO :SetIDPID  FROM firstlook.

I have over 25+ years in Health Care integration and 10+ years experience with Ensemble interface development.

Rolling off my project soon and looking for my next contract.

Looking for long term projects where I can leverage my Ensemble and Epic Bridges experience

Hello everyone!

I am writing a SQL CALL (using JDBC) to a stored procedure that outputs a structured object (Oracle Object).

Since Caché 2017 the SQL engine has included new set of statistics. These record the number of times a query is executed and the time it takes to run.

This is a gold mine for anyone monitoring and trying to optimize the performance of an application that includes many SQL statements but it isn’t as easy to access the data as some people want.

This article and the associated sample code explains how to use this information and how to routinely extract a summary of daily statistics and keep a historic record of the SQL performance of your application.

What is recorded?

Function as a service (FaaS) is a category of cloud computing services that provides a platform allowing customers to develop, run, and manage application functionalities without the complexity of building and maintaining the infrastructure typically associated with developing and launching an app. Building an application following this model is one way of achieving a "serverless" architecture, and is typically used when building microservices applications.  

Wikipedia

FaaS is an extremely popular approach to running workloads in the cloud, allowing developers to focus on writing code.

This article will show you how to deploy InterSystems IRIS methods in a FaaS way.

The Complex Recordmapper specify a map for headers, body, and trailers, but it expects all three to have fixed Leading Data to identify the record type. But what if the Header and Trailer have Leading Data, but not the body records? I can't seem to find a way to do this.  For example:

HEADER|194|2012|Fall|20
12345|Adams|John|Michael|2|john.michael.adams@example.com|617-999-9999
12347|Jones|Robert|Alfred|1|bobby.jones@example.com|
TRAILER|8|100

Ideas?

Hi Community,

We'll look at moving InterSystems workload to the public cloud, then take a deep dive into the current architectures on the InterSystems cloud platform:

⏯ InterSystems Solutions in AWS

Welcome to the February'22 Community Release!

We're pleased to present our brand new Community Event Calendar for InterSystems developers: 

🎯 https://community.intersystems.com/events 

In this calendar, you will see the history of DC events. Find out about events that are happening now or soon, check out past events, and watch recordings of Community's webinars and meetups.

Let's take a closer look at how to use it.

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in February 2022:

This is the third part of the series of articles on migrating from the main databases on the market to InterSystems IRIS. In this part, the procedures for migrating from DB2 will be detailed.As described in previous articles, there are currently a few options to do the migration. However, the two most popular options include the usage of DBeaver (https://openexchange.intersystems.com/package/DBeaver) or SQLGateway. The first one will be demonstrated in this article, and the second one is presented in an excellent article by Robert Cemper, DB Migration using SQLgateway (https://community.

New month, new code golf!

You will receive a string with a label code with numbers and letters. Our challenge is to check if this code begins with 1, 2, or 3 and ends with A, B, C, S, or R. It should return true(1) if so or return false(0) otherwise. As usual shortest solution wins.

##Input "198739A79D9R"

##Output 1

##Note

• The string only contains numbers and upper-case letters. No other special characters.
• Use this code to check the solution length
• You also can use this test case here

Rules

1. The signature of the contest entry MUST be:

Class codeGolf.

I am using the 

import intersys.pythonbind3 as pyb

conn     = pyb.connection()
conn.connect_now(...)
    
db      = pyb.database(conn)
qry        = pyb.query(db)
obj        = pyb.object(db)

for connection to the cache instance

However when I run this class method, The error message  indicates the method does not exist:

print(db.run_class_method("SYS.Database","GetStatus",[]))

intersys.pythonbind3.cache_exception: file=intersys/pythonbind3.c line=3034 err=-1000 message=<METHOD DOES NOT EXIST> 148 runMtdLow+22^%SYS.BINDSRV GetStatus,SYS.Database

I can not find the class reference docs for

I am writing a Python tool to query our cache instances for various information. I have set up the connection without issue:

import intersys.pythonbind3 as pyb  

conn     = pyb.connection()
conn.connect_now(.....)
    
db      = pyb.database(conn)
qry     = pyb.query(db)
obj     = pyb.object(db)

I wanted to make the call:

execRes = qry.prepare_class("SYS.Database",'FreeSpace')

But fetching fails because of data mismatches ( as I understand from other posts) and my testing bears out this type of failure.

Instead I opted to attempt a query:

execRes =

What is the purpose to use Emergency Access Mode in Cache? How to establishes a Connection without performing authentication?

Hi Developers, 
We are excited to announce that InterSystems will be a Platinum sponsor of Hacking Health Camp - big professional HealthTech conference and hackathon, which will take place in-person in Strasbourg, France on March 25-27, 2022. 

On March 8, 2022 @Guillaume Rongier will carry out a webinar "How FHIR can help you develop your health applications" (Webinar language: French). Register here.

At the hackathon, InterSystems will have a challenge for hackers on using InterSystems FHIR cloud services.

Learn more on official website and join us in-person in France!

I want to have a script that can run from the usual unix, linux, or aix command line. It has to be able to get into an irissession and use set statements to get data using sql. It seems like I'm in a catch-22. When I use the irissession SERVER command at the command line, I can't run a script. When I put the irissession SERVER command in a script, it won't run anything in the script after that.

My goal for this script is to get this information and put it into a file which I can then parse.

Hi Community,

Let's meet together at the online meetup with the winners of the InterSystems Python contest!

You'll have an opportunity to have a discussion with InterSystems Product Managers on the new IRIS 2021.2 Embedded Python functionality, Q&A on Python, etc. Our winners' demo included!  

Date & Time: Thursday, March 3 – 10:00 EDT