All
Accepted answers
Evgeny Shvarov · Feb 21, 2022 go to post

Turned out, that this behavior can be adjusted by removing the Final clause from DDL generation via the following flag:

set sc=$SYSTEM.SQL.Util.SetOption("DDLFinal",0,.oldval)
Evgeny Shvarov · Feb 16, 2022 go to post

It's not only for Eastern and Central Europe, @Ben Spead ! Any startup from any region is very welcome! The majority of activities will be online! Besides the Czech Republic, we already have applications from USA, UK, Netherlands, UAE, Ukraine and invite startups to apply!

Evgeny Shvarov · Feb 14, 2022 go to post

If you need to export the result of SQL to CSV you can use csvgen lib. 

install csvgen:

USER>zpm "install csvgen"

Perform export:

USER>set query="select * from your.classname"

USER>w ##class(community.csvgen).SQLToCSV(";",1,"/folder/file.csv",query)

1
Evgeny Shvarov · Feb 13, 2022 go to post

Snippets are great and deserve attention, but one-liners have a very certain use case, when you can execute it from the command line or as a docker image tweak

Evgeny Shvarov · Feb 12, 2022 go to post

And images with ZPM package manager 0.3.2 are available accordingly.

From clause could look like:

FROM intersystemsdc/iris-community:2022.1.0.114.0-zpm

And change the image to any of the following:

intersystemsdc/iris-community:2022.1.0.114.0-zpm
intersystemsdc/irishealth-community:2022.1.0.114.0-zpm
intersystemsdc/irishealth-ml-community:2022.1.0.114.0-zpm 
intersystemsdc/irishealth-community:2022.1.0.114.0-zpm
intersystemsdc/iris-community:2021.2.0.651.0-zpm
intersystemsdc/iris-ml-community:2021.2.0.651.0-zpm
intersystemsdc/irishealth-community:2021.2.0.651.0-zpm 
intersystemsdc/irishealth-ml-community:2021.2.0.651.0-zpm  

Also you can benefit from the latest and preview tags. Latest is equal to the latest GA IRIS, and preview is for the latest Preview version. e.g.

FROM intersystemsdc/iris-community:2021.2.0.651.0-zpm

equals to:

FROM intersystemsdc/iris-community:latest

FROM intersystemsdc/iris-community

And 

FROM intersystemsdc/iris-community:2022.1.0.114.0-zpm

equals to:

FROM intersystemsdc/iris-community:preview

And to launch IRIS do:

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community:2022.1.0.114.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-ml-community:2021.2.0.651.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community:2021.2.0.651.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community:2021.2.0.651.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-ml-community:2022.1.0.114.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community:2021.2.0.651.0-zpm

And for terminal do:

docker exec -it my-iris iris session IRIS

and to start the control panel:

http://localhost:9092/csp/sys/UtilHome.csp

To stop and destroy container do:

docker stop my-iris
Evgeny Shvarov · Feb 11, 2022 go to post

Updated to 651, thanks, @Jeff Fried!

Also, we have the latest tag for ZPM images, so this will take the latest:

FROM intersystemsdc/iris-community:latest

Or just like this:

FROM intersystemsdc/iris-community
Evgeny Shvarov · Feb 6, 2022 go to post

BTW, there is a very good one-liner to install ZPM, cortesy of @Guillaume Rongier:

set $namespace="%SYS", name="DefaultSSL" do:'##class(Security.SSLConfigs).Exists(name) ##class(Security.SSLConfigs).Create(name) set url="https://pm.community.intersystems.com/packages/zpm/latest/installer" Do ##class(%Net.URLParser).Parse(url,.comp) set ht = ##class(%Net.HttpRequest).%New(), ht.Server = comp("host"), ht.Port = 443, ht.Https=1, ht.SSLConfiguration=name, st=ht.Get(comp("path")) if 'st { w $System.Status.GetErrorText(st) q } set xml=##class(%File).TempFilename("xml"), tFile = ##class(%Stream.FileBinary).%New(), tFile.Filename = xml do tFile.CopyFromAndSave(ht.HttpResponse.Data) do ht.%Close(), $system.OBJ.Load(xml,"ck") do ##class(%File).Delete(xml)
Evgeny Shvarov · Feb 3, 2022 go to post

Hi @Julius Kavay! I agree with you! Could you please submit your suggestion on our dedicated Community Ideas site? I could do it too, but it's great to know that it's not an employee who needs that but partners, and ... I already submitted a lot :)

Sign with your DC credentials. 

Evgeny Shvarov · Jan 31, 2022 go to post

Included it into csvgen module.

to export SQL to CSV you can do the following:

USER>set query="select * from your.classname"
USER>w ##class(community.csvgen).SQLToCSV(";",1,"/folder/file.csv",query)
Evgeny Shvarov · Jan 24, 2022 go to post

And images with ZPM package manager 0.3.2 are available accordingly:

intersystemsdc/iris-community:2021.2.0.651.0-zpm
intersystemsdc/iris-ml-community:2021.2.0.651.0-zpm
intersystemsdc/irishealth-community:2021.2.0.651.0-zpm 
intersystemsdc/irishealth-ml-community:2021.2.0.651.0-zpm  
intersystemsdc/iris-community:2021.1.0.215.3-zpm
intersystemsdc/irishealth-community:2021.1.0.215.3-zpm
intersystemsdc/irishealth-ml-community:2021.1.0.215.3-zpm
intersystemsdc/irishealth-community:2021.1.0.215.3-zpm

And to launch IRIS do:

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community:2021.2.0.651.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-ml-community:2021.2.0.651.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community:2021.2.0.651.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community:2021.2.0.651.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-ml-community:2021.2.0.651.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community:2021.2.0.651.0-zpm

And for terminal do:

docker exec -it my-iris iris session IRIS

and to start the control panel:

http://localhost:9092/csp/sys/UtilHome.csp

To stop and destroy container do:

docker stop my-iris

And the FROM clause in dockerfile can look like:

FROM intersystemsdc/iris-community:2021.2.0.651.0-zpm

Or to take the latest image:

FROM intersystemsdc/iris-community
Evgeny Shvarov · Jan 21, 2022 go to post

Hi @Werner Noske! It looks like you are trying to work on your project in the built-in USER namespace and database.

Don't. 

USER namespace is for testing/demo purposes.

You are welcome to start a new clear database from scratch. 

For example, you can follow this template that starts with a new clear namespace and database IRISAPP.