Question Robert Cemper · 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: #Globals #Other 2 5 0 305
Question Robert Cemper · Mar 16, 2023 ? un-publish in ZPM ? During a discussion of implementing a private ZPM RegistryI met the question of how to unpublish (or lock) a published package. Digging articles and docu up and down I was unable to find an answer.Any hint on where to search is welcome. NB. local install / uninstall is clear. #InterSystems Package Manager (IPM) #InterSystems IRIS 1 2 0 219
Question Robert Cemper · Mar 15, 2023 ? does Community License include Sharding ? I found a package on OEX for a Sharding DemoIf Sharding is NOT included in the Community LicenseI can not use the Community Distribution but require a different one.And have to add ZPM manually. #Docker #Sharding #Testing #InterSystems IRIS 1 2 0 139
Question Robert Cemper · Mar 15, 2023 ? how to get Docker Host IP ? When I run my IRIS in a Docker Container I know the host an know the mapped portsso access is no problem. BUT: is it possible from my IRIS- inside a Container- 'inside' Dockerto find the actual IP address of the Host?This may sound strange, but for error tracking, it could be quite important. #Docker #Error Handling #InterSystems IRIS 1 9 0 4.7K
Question Robert Cemper · Mar 14, 2023 ? No Terminal access to docker images ? To prepare a migration to IRIS I use Docker images.The (aged) application is built around Caché TerminalAnd on Windows, IRIS uses the same ctelnetd.exe as Caché. In my Docker installation, Telnet Settings are just grayed out in SMP.and my Terminal can't 'connect.Port mapping is OK and verified with TCP Working from the console in Docker with the whole set of ESC andscreen formatting is not acceptable.We tried WebTerminal but there is just no Partition behind as in Terminal. #Docker #Management Portal #System Administration #InterSystems IRIS 2 4 0 234
Question Robert Cemper · Mar 13, 2023 Stream migration from old Caché format to IRIS During a migration from a rather old Caché Version (2016.1) to IRISI met the problem to migrate Streams.The difference in the storage Global is minimalIt's not a big effort to do it manually for a few streams.But for some thousand streams I hope there is a tool already available.But where? #Globals #Caché #InterSystems IRIS 2 2 0 312
Question Robert Cemper · Mar 13, 2023 ? Date before Dec.1840 ? Negative $H(orolog) ? To most of us it's almost dogmatic that $H can't be negative! This is correct concerning the COS Special Variable $HOROLOG.No doubt. It's the presentation of the actual date & time.http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=... #Other 14 4 1 764
Question Robert Cemper · Mar 13, 2023 ECP between IRIS and Caché / Ensemble Those of you that worked already with ECP might know that it operates not only acrossoperating systems, processor technologies (big-little-endian), but also -with limits- across versions in C/E.This cross-version feature also includes IRIS (verified for 2020.1) and C/E (2018.3) #ECP #Globals #Caché #Ensemble #InterSystems IRIS 7 2 1 673
Article Robert Cemper · Mar 8, 2023 2m read The spooky ascetic Property During my recent work on Tutorial - Working with %Query #1I met a Class Property that is quite different from its same-named relatives.It is there since 'ever' but is rarely used, Related doc doesn't help so much. #Other 3 2 0 240
Question Robert Cemper · Mar 3, 2023 ? %QUERY Wizard in VSCode ? For my recent tutorial, I used %Query Wizard of Studio. Could any of the VSCode experts please show me how to generateQuery Statement with input parameters, CONTAINID , ROWSPECand the required class methods- <queryname>Execute()- <queryname>Fetch()- <queryname>Close() I was just not able to do it. #ObjectScript #SQL #VSCode 3 3 0 197
Article Robert Cemper · Mar 3, 2023 2m read Reviews on Open Exchange - #25 If one of your packages on OEX receives a review you get notified by OEX only own YOUR package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. I also placed a bunch of Pull Requests on Github when I found a problem I could fix. Some were accepted and merged, and some were just ignored. So if you did a major change and expect a changed review just let me know. #Open Exchange 2 0 0 118
Article Robert Cemper · 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. #Other 12 1 1 351
Article Robert Cemper · Mar 2, 2023 5m read Tutorial - Working with %Query #3 My previous article introduced you to the COS based Custom Class Query.There were some features missing like more lines of the stream displayedand numbered. #Other 8 1 0 220
Article Robert Cemper · Mar 2, 2023 5m read Tutorial - Working with %Query #2 My previous article introduced you to SQL based Basic Class Querywhere a clever wizard created all the required code for you and your essentialcontribution was an SQL statement. Now we enter the real Custom Class Query that provides more freedom butrequires a deeper understanding of the mechanic behind the scene.The full code example is again on GitHub #Other 8 1 0 268
Article Robert Cemper · 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 #Other 8 4 1 523
Article Robert Cemper · 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. #Other 1 1 0 302
Question Robert Cemper · Feb 26, 2023 Code assist in VSCode ? In Studio, I had a set of nice Assist Functions to create correct code.. Do they exist in some similar way also in VSCcode ? Same for SOAP wizard? #VSCode 1 2 0 253
Article Robert Cemper · Feb 6, 2023 2m read Reviews on Open Exchange - #24 If one of your packages on OEX receives a review you get notified by OEX only own YOUR package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. #Open Exchange 4 2 0 182
Question Robert Cemper · Feb 3, 2023 Why to run ISC Agent in Demo Docker ? For quite some time I am bored by slowly starting Docke Demos from OEX.I type docker-compose up - d and after a few seconds docker-compose logs And I just see ISC Agent was started and is hanging aroundNo IRIS instance is up yet. #Docker #InterSystems IRIS 4 2 0 225
Article Robert Cemper · Jan 30, 2023 1m read JSONfile-to-Global #2 The power of the presented tool becomes visible with a large JSON file.The example I have prepared is composed of the daily results of AoC 2023.Anonymization makes it usable for demo purposes. #Globals #JSON #Tips & Tricks #Tools #InterSystems IRIS #Open Exchange 2 1 0 235