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.

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.LabelCode
{

ClassMethod Validate(s As %String)

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 2017.

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 = qry.prepare("select DatabaseName, Directory, MaxSize,

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

Time travel is like visiting Paris. You can't just read the guide, you have to throw yourself into it. Eat the food, use the wrong verbs, get double the charges, and end up kissing complete strangers.

The Doctor

We are now going to travel through time, that is, we are going to see future and past dates and how to calculate them in different formats. The TARDIS doesn't wait, take the controls and hold on tight.

i'm trying to extend both the MemberEnrollment and the MedicalClaim objects in HS.  The CareProvider is perfect for some of my extensions (Operating provider, referring provider, third-party insurer), but the documentation says https://docs.intersystems.com/irisforhealthlatest/csp/docbook/DocBook.U…:

I need something that is just like a CareProvider, and I will be using the CarePRoviderType as a CodeTableDetail.  

Why is CareProvider excluded?

Hi,

I'm looking through some journal entries in the hope of finding the root source of an issue.
I was wondering if and how you can map a "ECP system id" to a server.

Any hints would be welcome

Best regards
Ivo

Hey everyone,

The first first tech article contest in Spanish is over. Thanks to our wonderful participants for their contributions! We got

🌟 8 AMAZING ARTICLES 🌟

So it's time to announce the best of them!

Hello, developers!

In this article, I will show you how to configure FHIR repository + OAuth2 authorization server/resource server on IRIS for Health following the previous article.

In Part 1, we introduced the preliminary preparations, configuring the OAuth2 authorization server, and obtaining the access token.
Part 2 will show you how to build an FHIR repository and configure an OAuth2 client/resource server.

The FHIR repository configuration and the OAuth2 client/resource server that we will configure today can be used separately from the IRIS instance of the OAuth2 authorization server that

NOTE: we previously found an issue with the 2021.1.1.324.0  builds.   The 2021.1.1 maintenance releases have been removed from the WRC and have been  replaced with 2021.1.2.336.0 builds.  2021.1.2 containers will be available shortly.

Two new sets of maintenance releases are now available: 

• Caché  2018.1.6, Ensemble 2018.1.6, and HSAP 2018.1.6
• InterSystems IRIS 2020.1.2, IRIS for Health 2020.1.2, and HealthShare Health Connect 2020.1.2

Installation kits and containers can be downloaded from the WRC Software Distribution site. Container images for the Enterprise Editions of InterSystems IRIS and IRIS for Health and all corresponding components are available from the InterSystems Container Registry.

Hi,

I was playing around with the python binding for caché (2018.1.4) and I ran into some problems.

When executing the class query "List" from SYS.Database the  pythonbind interface throws an exception, that seems to be caused by a mismatch of the defined SQL datatypes for this query and what is actually returned (or the lack of type conversion in the pythonbind interface).

Is this a known issue ? Are there solutions/workarounds for this,
Or is this a bug ?
 

The details:

When executing "List" from SYS.Database there is an error for every datarow fetched.
When executing "FreeSpace" from SYS.Database

I entered the irissession SERVER command and got the prompt PROMPT>

Now I want to exit this and return to the generic aix prompt $

I try q, quit, e, exit... none of these work.

Hello dear community

I tried to run windows command from an intersystems terminal using objectscript routine.

routine :

 write:test $test,! else  write "pipe failed",!    use 0 write line,!

Hi Team,

How I can migrate my all the existing Namespace, Web Application, Database from IRISHealth 2019 to 2021.

Thanks,

Ankur Shah

Hi There, 

I am reaching out to the community to see if anyone has implemented SSO via SAML into TrakCare from Azure AD? 

Also looking to see if anyone has come across automated role provisioning, I have seen this from an IRIS perspective but not directly into TrakCare. 

Thanks in Advance

Cheers, 

TC

Hi Community,

I would like to migrate a Zen application to Iris but I am facing issue below:

so far I was not able to solve this issue myself, is there somebody who has some suggestions?

Thanks!

7) You need the right driver

If you want to execute the LOAD DATA sql command you have to choose the driver from 2021.2! If you select the wrong driver and use the LOAD DATA sql command you get something like

 Error: [SQLCODE: <-1>:<Invalid SQL statement>]
[Location: <Prepare>]
[%msg: < LITERAL ('%qpar') expected, : found^LOAD DATA FROM FILE :%qpar>]

I've forked the jdbc driver repo https://github.com/intersystems-community/iris-driver-distribution and added the driver from InterSystems IRIS Version 2021.2.0.617

You can download the intersystems-jdbc-3.3.0.jar from here:

I am trying to send an HTTP request and getting "SSL/TLS error return from SSL_connect()." error (Cache 2013). No modification in SSL/TLS Configuration helped. Could anyone point me in the right direction?

Thanks

Hi Community，

I have forgotten my gateway username and password. 

C:\InterSystems\IRISHealth\CSP\bin.csp.cni has a user name, but pwd is encrypted ,how to decrypt?

Thx！

Hello everyone! Don't miss the Developer Community Post Digest for February 2022.

Hey Developers,

It's time to announce the winners of the InterSystems Python contest! Are you ready?

A storm of applause goes to these developers and their applications:

Hey Developers! Here is a digest of new solutions and applications submitted to the InterSystems Open Exchange in February 2022.

Hello all,

I've seen that to install any python library we just need to call this:

C:\InterSystems\IRIS\bin>irispip install --target C:\InterSystems\IRIS\mgr\python geopy

Is there a way to install the libraries in a different directory and set up the system to load the python from that other directory?

Hey Community,

We greatly appreciate all your feedback on the InterSystems Python programming contest. Please take a few questions to help us improve our contests.

👉 Quick survey: InterSystems Python Contest Survey 

I need someone to help me set up Community version of IRIS on an Amazon virtual server so that I can develop some versions of a highly secure database for review by investors. Any help would be appreciated. Some initial investment funds are available but so far this is a small project with big dreams.

Is there a way, for testing purposes at least, to change a CSP session over to a different user? We have a lot of things in our system that are allowed or restricted based on the user login, so it would be useful for me to be able to occasionally run as a different user to see how things look and work for them. I've tried using the %CSP.Session.Login function, but that still shows the CSP session as being from the original user, not the one I've switched to.