Rechercher

Question

Ephraim Malane · Déc 22, 2022

Hi Community,

My IRIS.DAT file is corrupted on one of my Edge productions in the development environment and as a result, I cannot start production.

I would like to recover it if there is a way to do so, please assist.

Regards,

8 Comments

Discussion (8)4

Connectez-vous ou inscrivez-vous pour continuer

Veuillez noter que cette publication est obsolète.

Question

Vishnu G · Déc 14, 2022

#HL7 #InterSystems IRIS for Health

Does InterSystems has CDS Hook implementations?
if yes, where I could get the details.

7 Comments

Discussion (7)3

Connectez-vous ou inscrivez-vous pour continuer

Article

Dzmitry Rabotkin · Déc 3, 2022 2m de lecture

Open Exchange

#Docker #InterSystems IRIS for Health

Hi, I would like to tell you how easy it is to spin up IRIS for Health docker container in compute engine(VPS) in google cloud.

I know that to run IRIS for Health in AWS is pretty simple and straightforward, but I wanted to tried if its same easy in GCP environment.

Create vm instance. 2GB RAM is more than enough.

I used Debian 11 as Linux distro.

Standart persistent disk is cheaper.

Don’t forget to allow http, https traffic

Last thing for setting up virtual machine is allow external ports in firewall rules.

I allow here only 52773 which is for web user interface. My Kotlin app will run on same vm and use 1972 internally, so I didn’t allow it too.

Let’s Install docker-compose then run IRIS:

sudo apt install docker-compose

sudo docker run --name iris -d --publish 1972:1972 --publish 52773:52773 containers.intersystems.com/intersystems/iris-community:2022.1.0.209.0 --check-caps false

I found that command in InterSystems documentation pages here: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=ACLOUD

I only added 2 things:

1. “-d” after name of container “iris” which means run in detached mode. So container will still run on background after you close SSH shell.

2. “- -check-caps false” at the end. I immediately found it in this article which was very helpful. https://community.intersystems.com/post/using-intersystems-iris-containers-docker-201014

sudo docker ps

Container is up and running just with 1 command:

Now check UI in browser:

This link I found at Intersystems documentation pages: https://docs.intersystems.com/irisforhealthlatest/csp/docbook/DocBook.UI.Page.cls?KEY=GSA_USING_PORTAL
http://35.222.2.215:52773/csp/sys/UtilHome.csp

35.222.2.215 is external ip of my Virtual machine.

52773 port we exposed with docker run command.

Default Login: SuperUser

Password: SYS

Now you have to change default password:

Congratulations, you are logged in:

ATTENTION: don't forget to delete VM instance, so you lose money on hosting.

Conclusion:

In this article I only covered how to run IRIS for Health community edition docker container in google cloud linux environment. Other part of my Kotlin/Intersystems journey will be in description of our project Dia Bro App. Please check it up and vote if you like the idea.

Discussion (0)1

Connectez-vous ou inscrivez-vous pour continuer

Article

Megumi Kakechi · Nov 28, 2022 2m de lecture

#SQL #Conseils et astuces #InterSystems IRIS #InterSystems IRIS for Health

Question:

IRISでは、PostgreSQLやMySQLで使うことができる、開始位置や取得件数を指定する LIMIT句やOFFSET句をサポートしているでしょうか？

Answer:

※2025/4/17更新：IRIS2025.1 以降のバージョンでは、LIMIT/OFFSET句をサポートするようになりました。ご参考

残念ながらサポートしていません。
ただ、代わりに使える同様の方法がありますのでご紹介します。

以下のようなSQLクエリをIRIS SQLで行うとします。

SELECT *
  FROM Sample.Person
ORDER BY Name
 LIMIT 3 OFFSET 5

---------------------------------------------------------------------------------
1. サブクエリとビュー ID (%VID)を使用する方法
---------------------------------------------------------------------------------

IRISでは、ビューまたは FROM 節のサブクエリで返される各行に整数のビュー ID (%VID) を割り当てることができます。
%VIDを使用すると、以下のサンプルのようにして同様のことが実現できます。
※%vidについて

SELECT *, %vid FROM (SELECT top all ID, Name
                     FROM Sample.Person
                     ORDER BY Name) v
WHERE %vid BETWEEN 6 AND 8
// 6番目から3つ分 --> 8番目まで

---------------------------------------------------------------------------------
2. OFFSET目までのデータを除いて TOP する方法
---------------------------------------------------------------------------------

SELECT TOP 3 ID, Name FROM Sample.Person WHERE ID NOT IN (SELECT TOP 5 ID
                 FROM Sample.Person
                 ORDER BY Name)
ORDER BY Name

---------------------------------------------------------------------------------
3.row_number() 関数を使用する方法
---------------------------------------------------------------------------------

IRIS 2021.1以降でサポートされるようになったウィンドウ関数の ROW_NUMBER() を使用して実現することも可能です。

SELECT * FROM (
  SELECT row_number() OVER (ORDER BY Name) AS rn, ID, Name
  FROM Sample.Person 
) AS e 
WHERE e.rn BETWEEN 6 AND 8 ORDER BY Name

是非お試しください。

Discussion (0)0

Connectez-vous ou inscrivez-vous pour continuer

Question

William Glover · Nov 24, 2022

#InterSystems IRIS

As the title says I want to be able to hide code I deploy to TIe.

3 Comments

Discussion (3)1

Connectez-vous ou inscrivez-vous pour continuer

InterSystems IRIS.DAT file corrupted

Does InterSystems has CDS Hook implementations?

Guide how to run and use IRIS for Health docker image in GCloud

IRIS SQLでは LIMIT/OFFSET句のような機能をサポートしていますか？

Is there a way of masking code in studio, such as password protection or with user rights?