Article
· Mar 2, 2023 5m read
Tutorial - Working with %Query #1

The title of the contest subject is not quite precise but addresses the %Library.classes involved.
What is meant is officially named Class Query and is dating back to the early days of Caché.
CLASS is used because it is embedded in a COS class.
Though there is a precise description in the official documentation it remains rather abstract.
My tutorial should guide you step-by-step through a simple example in COS to make it tangible to you

8 4
1 494

As you know in Caché / IRIS you have the possibility to define a property as Multidimensional as documented here:
https://docs.intersystems.com/iris20201/csp/docbook/DocBook.UI.Page.cls?KEY=GOBJ_proplit#GOBJ_proplit_multidim
and the explanation of how to use it
https://docs.intersystems.com/iris20201/csp/docbook/Doc.View.cls?KEY=GOBJ_proplit#GOBJ_proplit_multidim_values

Though the access is quite comfortable (in traditional COS sense) there are 2 main restrictions that hurt:

#1) It is not saved to disk unless your application includes code to save it specifically.
#2) It cannot be stored in or exposed through SQL tables
there are some more
I'll show how to overcome these limits

14 1
2 531
Question
· Mar 17, 2023
A confusing experience

During my last migration to IRIS I met this Compatibility parameter

  • NullSubscripts true
0 - Throw error when referencing a null subscript.
1 - Null subscript references do not throw an error.

The consequences are shocking. This was allowed:

2 5
0 283
Article
· Feb 28, 2023 2m read
Break the limits of your server

Hi developers!

You are experts in IRIS and know all tricks. The functionality of $ZF(-1,-2,-100, ......)
is nothing new to you And you know the limits of this functionality.
Both give you access to your local server command line environment. And that's it.

1 1
0 280
Announcement
· Mar 6, 2023
CCR View Page Opt-In Release

Hello CCR Users,

The new CCR view page is now available to all users via an opt-in toggle a at the top and bottom of the view page.

We hope all users will give the new UI a try and provide us with any feedback that you have through your normal support channels.

Thank you to the beta users who have been using this page for a while, making sure its full release goes smoothly! You can always update your beta user status here.

Thanks!

3 1
0 190
Article
· Mar 2, 2023 4m read
Tutorial - Streams in Pieces

This tutorial is a follow on to Working with %Query
It was displaying the content of the input stream chopped in fixed-size chunks.
But often those streams are structured and have well-defined separators (e.g HL7)
So as a side subject of this tutorial, this chapter shows how to break a stream into PIECES.

It is exactly the same idea as the $PIECE() function for strings with some add-ons.

12 1
1 305
Article
· Mar 2, 2023 5m read
Tutorial - Working with %Query #2

My previous article introduced you to SQL based Basic Class Query
where a clever wizard created all the required code for you and your essential
contribution was an SQL statement.

Now we enter the real Custom Class Query that provides more freedom but
requires a deeper understanding of the mechanic behind the scene.
The full code example is again on GitHub

8 1
0 248
Announcement
· Feb 14, 2023
Community Roundtable: AI / ML

Hi Community,

We are gathering again for the next Community Roundtable. Many of you asked for a roundtable about AL / ML, and we are delighted to bring such a roundtable to you!

Our invited expert from InterSystems: @Thomas Dyar Product Specialist - Machine Learning.

Join our 60-min discussion, prepare your questions, and use cases! There will be a short demo as well.

UPDATE: the recording is available here.

6 5
0 289

Hi Community,

Please read this when you have the time and keep an open mind. Also, you are welcome to tell me it is a terrible idea.

The main reason for this post

If you look at NPM, it has 1.3 million packages. Now ask yourself, is this an achievement or a nightmare?
How many of those packages are no longer supported?
How many of those packages break compatibility on version changes?
How do you know which one to use?

11 13
2 219
Article
· Jan 23, 2023 2m read
Global-Streams-to-SQL

In general Global Streams are data objects embedded in Classes / Tables.
Using and viewing them with SQL is normally a part of the access to the containing tables.

SO WHAT?

During debugging or searching for strange or unexpected behavior there could be the need to
get closer to the stored stream. No big problem with direct access to Globals with SMP or Terminal.
But with SQL you are lost.
So my tool provides dynamic access to Global Streams wherever you may need this
Special thanks to @Oliver Wilms for the inspiration for this tool.

6 1
1 362

Hi ,

I am trying to work out how to install the intersystems-jdbc-3.3.1.jar file onto a windows server to set up a connection between athrid party application and an Iris database.

Is there an installer ? the java -jar etc command does not work "could not load main class " . Added the folder to the system path .

Running Eclipse temurin but I do not work with java at all, other than these very specific points where need to get applications to run .

If someone could point me to a guide or instruction that would be of great assitance

Cheers

0 6
0 479
Article
· Jan 23, 2023 2m read
Global-Streams-to-SQL #2

Some technical background information

There is not just one class in this package: rcc.gstream.cls but also rcc.gstreamT.cls

While rcc.gstream works with direct access to the stream globals, the *T version uses
a Process Private Global (PPG) as Temporary storage.
using SELECT * FROM RCC.gstreamT WHERE RCC.useT('^jpgS')=1 and similar.

2 0
0 169
Announcement
· Dec 30, 2022
Happy New Year

Dear community!

It was an amazing 2022 with all of you. Great questions and articles around the whole year and this brings us the most valuable gifts -- wisdom and knowledge.
I want to thank you all for a great year full of fun and pleasure.

This community rocks.

7 6
0 176
Question
· May 24, 2022
Questions MSM-Workstation

Hello, my name is Roger, I work in a big hospital in Brazil, I'm new to the MUMPS area, I was given an assignment to try to stabilize our MSM/MUMPS system, we have licenses for 1200 connections, however, the MSM starts having problems when we reach about 990 connections, the terminal has a timeout, it gets stuck. Looking at the MSM settings parameters I noticed the following default settings, could this be related?

0 6
0 458

Overview

Predictable storage IO performance with low latency is vital to provide scalability and reliability for your applications. This set of benchmarks is to inform users of IRIS considering deploying applications in AWS about EBS gp3 volume performance.

Summary

  • An LVM stripe can increase IOPS and throughput beyond single EBS volume performance limits.
  • An LVM stripe lowers read latency.
4 1
0 1.8K

Today we have made the new CCR view page the default for CCR beta users.

The option to toggle back to the classic UI is available in the navigation bar at the top and bottom of the page.

Please let us know of any issues you encounter or general feedback you have on the page, and thank you to everyone who tried the page in its initial release and provided us with great feedback already!

2 1
0 163

Hi Community,

The day has arrived — InterSystems FHIR Healthtech Incubator Caelestinus Final Demo Day, November 30, 2022!

We started Caelestinus 8 months ago in March with 22 outstanding teams. Today 15 teams will pitch what they have achieved so far and their message to the market!

I’m pleased to invite everyone to InterSystems FHIR Health Tech incubator Caelestinus Demo Day, which will happen in a hybrid online/offline mode: you can watch pitches online via www.caelestinus.tech starting at 2 p.m. CET or go in-person in IKEM — Institute for Clinical and Experimental Medicine, the largest Czech medical research and clinical hospital.

https://www.youtube.com/embed/sC-R9MflORg
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

3 1
0 210

Hello,

Thank you for reading this question, and thank you for your time and replies.

I was wondering which ways, tools, mechanisms, or vias would you recommend to teach to kids, teens, adults, being your sons / daughters or not; your passion or likelihood for programming and computers?

I know there are some programming free games like the following ones:

2 5
0 260

Hi Community,

Let's meet virtually at our first Community Roundtable! This will be a 45-min friendly discussion on a given topic: VSCode vs Studio.
Imagine that we just gathered together to share our thoughts, experiences, tips, and tricks. If you want to discuss specific questions within a given topic - please share them in the comments.

Watch recording:

https://www.youtube.com/embed/bTiL9GzpIJQ
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

4 10
0 641