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

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.

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 :

Zpipe  quit ; CPIPE example to run host console command
cmd(command="",test=0) ;
 if command="" set command="dir"
 quit $$execute(command,test) execute(cmd,test) Public {
 set dev="|CPIPE|1"
 set $zt="cls"
 set empty=0
 open dev:cmd:0
 write:test $test,!
 else  write "pipe failed",! quit 0
 while empty<3 {
    use dev read line 
    set empty=$s($l(line):0,1:$i(empty))
    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

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: https://github.

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！

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:

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?

Hi Community, 

Join us for this introduction to the terminology and workflow of using OAuth 2.0 with an HL7 FHIR server:

⏯ Securing FHIR Applications with OAuth 2.0 (Part 1)

Hi Community ,

I have installed InterSystems IRIS Community in my personal laptop to do some POCs.

Here are the defined namespaces available:
     %SYS
     HSCUSTOM
     HSLIB
     HSSYS
     PPONUGOTINS
     USER

How to create samples in it?

please advice me.

Thanks,

Prashanth

Monitoring IRIS through SAM (sam:1.0.0.115)

While I've used to make it work in the past, I'm not able any more to fix the already faced issue : "State: Unreachable"

Despite all the ip-addresses attempts (or hostname = host.docker.internal)  and while "/api/monitor/metrics" is running well...

Could someone provide good practices to make it work cleanly ?

I have created person.csp in my namespace using studio and view->webpage then web page opened in below url

http://localhost:52773/csp/healthshare/pponugotins/person.csp

I have crated new web application  as /csp/test. only change is selected unauthenticated

http://localhost:52773/csp/test/person.csp

it should open same webpage , but showing "Invalid Action"

please help me what should i do.

I need a csp page which should not ask any authentication

Thanks,

Prashanth

Hello,

I'm using the InterSystems Iris odbc driver (DriverODBCVer=02.10) to get data from Iris table but it is slow.

Is there any options to improve performance ? Increase the packet size ?

Change to do in odbcinst.ini / odbc.ini to make it quicker ?

Thanks

Dear people,

I (really) spent hours on finding the maximum size a Global is allowed to be (for Windows, if that matters). All I seem to run into are database sizes (derived from a max number of blocks and block size), but I refuse to believe that is correct because too small to be realistic.  

It will  undoubtedly my fault that I don't understand or misread the concepts of "database" vs Globals, envisioning files as such while one set of functional Globals in one file (?

Hi Community,

I have created CSP page should show my Queue status.

Now I need to refresh this page every 5 min.(same like live score website) to reload new queue status.

Any tag in CSP will do this auto refresh?

Thanks,

Prashanth

I'm building a .Net Core Gateway container. Here's the issue.

As a final step I'm building a .Net Core 2.1 library. It has a runnable dependency - .Net Gateway, which I need to start first.

However dotnet publish generates .runtimeconfig.json and .deps.json only for my library and not for my dependency (.Net Gateway).

Is there a way to force dotnet to generate .runtimeconfig.json and .deps.json for a dependency?

With the latest improvements in support for Python in IRIS, and continued work on Python DB-API support by InterSystems. I've implemented IRIS support to the Django project where is Python DB-API is used to work with some other databases.

Let's try a simple application on Django, which stores its data in IRIS.

We are happy to share interesting information with you, as well as tell you why Python is good, where it is used.

Among the most used libraries are NumPy and Pandas. NumPy (Numerical Python) is used to sort large datasets. It simplifies mathematical operations and their vectorization on arrays. Pandas offers two data structures: Series (a list of elements) and Data Frames (a table with multiple columns). This library converts data into a Data Frame, allowing you to remove and add new columns, as well as perform various operations.

Hi Community,

for our forms validation we use XData to describe fields on server side.

These XData are in JSON like this

XData FormValidator [ MimeType = application/json ]
{
 {
  "username": {
   "required": true 
  },
  "email": {
   "datatype": "email"
  }
 }
}

When I try to use %JSON.Adaptor in same classes, IRIS throw an error at compile time

 ERROR #6301: SAX XML Parser Error: invalid document structure while processing Anonymous Stream at line 1 offset 23
  > ERROR #5490: Error running generator for method '%JSONGenerate:helora.worklist.

Voting time! 

Let's cast your votes for the best applications in the InterSystems Python Contest:

🔥 Vote for your favorites 🔥

How to vote? Details below.

Hey Developers,

We are pleased to invite you all to the next InterSystems online programming contest focused on Python! 

🏆 InterSystems Python Contest 🏆

Duration: February 7 - 27, 2022

In prizes: $10K - more prizes included!

In my article I described the work using iris.gref .
As the official documetation is rather slim on the subject it was necessary to dig into it.
Using the power of Python I was able to detect what I needed but was hidden.
I decided to share this with you. pydoc did the magic. 

Hey there,

I posted a reply to the recent video https://community.intersystems.com/post/new-video-building-data-driven-web-apps#comment-132511
with a slew of questions.  Wondering if someone can take a look a address my questions on that post or on this new thread.

I find many InterSystems learning to be challenging to follow, but I"m not sure if it's because my work computer is so locked down that I don't have all the right tools and permissions I need to do what the tutorial asks, or if I'm not understanding the basics of Cache/IRIS, or both!

Mike

We are planning to build a REST API with the Java Quarkus Framework.

• There'll be a connection pool;
• The DataSource instance will be automatically injected from the connection pool;
• We will use JDBI to do SQL instructions and this will give us automatic Connection and Statement management;

This Caché instance already have COS applications running and consuming connections and licenses.

After doing this, we will migrate to IRIS.

Is there any pitfalls that we must be aware before taking this approach?

If you want to see some code the PoC can be found here.

Thanks.

Hi contestants!

Here are the results of the bonus collections the applications of the Python Contest accomplished.

Here are the projects that scored it:

When designing a hierarchy in DeepSee, a child member must have only one parent member. In the case where a child corresponds to two parents, the results can become unreliable. In the case where two similar members exist, their keys must be changed so that they are unique. We will take a look at two examples to see when this happens and how to prevent it.

Example 1

There are a handful of states with a city named Boston. In my sample data, I have records from both Boston, MA and Boston, NY. My dimension is defined as:

City and State are simply strings in my case.