Article Robert Cemper · Oct 23 1m read Reviews on Open Exchange - #57 If one of your packages on OEX receives a review, you get notified by OEX only of YOUR own 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 1 0 0 20
Article Robert Cemper · Oct 21 2m read Practical use of XECUTE (InterSystems ObjectScript) If you start with InterSystems ObjectScript, you will meet the XECUTE command.And beginners may ask: Where and Why may I need to use this ? The official documentation has a rich collection of code snippets. No practical case.Just recently, I met a use case that I'd like to share with you. #Beginner #Docker #ObjectScript #InterSystems IRIS #InterSystems IRIS for Health 8 1 3 52
Article Robert Cemper · Oct 18 1m read Free Database Space by SwaggerTools Being impressed by the graphics of the package GBLSizeMonitor from @Ashok Kumar T I ask for his help, and this is the result of our cooperation.As in the previous package, all is running from a CSP page.And it is all classic CSP written with InterSystems ObjectScript, JavaScript, HTML #InterSystems IRIS Open Exchange app 6 2 0 55
Article Robert Cemper · Oct 14 3m read Sample for Beginners with Streams in IRIS To better understand Streams in IRIS I'll start with a short #ObjectScript #InterSystems IRIS Open Exchange app 5 2 3 57
Article Robert Cemper · Oct 6 1m read Reviews on Open Exchange - #56 If one of your packages on OEX receives a review, you get notified by OEX only of YOUR own 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 1 0 0 23
Article Robert Cemper · Sep 22 2m read Dashboard of database free space Finishing my previous example for multiple IRIS instances, I triedto compose a local single instance version. The step from the externalPython app to a version using embedded Python seemed to be obvious.This was a wrong assumption, as some Python libraries just refused installationinto my local Windows-based environment. #Analyzer #Dashboards #Databases #ObjectScript #System Administration #InterSystems IRIS Open Exchange app 2 3 2 61
Article Robert Cemper · Sep 20 2m read Snapshot DB free - Strategies These are the strategic plans of my example for the External Languages Contest 2025 #Databases #Python #System Administration #Tools #InterSystems IRIS Open Exchange app 2 0 0 48
Article Robert Cemper · Sep 20 1m read Snapshot of free disk space It's about an example for the External Languages Contest 2025 You get almost any information about your databases in IRIS using the System Management Portal. After passing several levels, you oftenget a wide list of items, but the interesting ones are hard to find. #Databases #Python #System Administration #Tools #InterSystems IRIS Open Exchange app 3 1 1 62
Article Robert Cemper · Sep 16 1m read Reviews on Open Exchange - #55 If one of your packages on OEX receives a review you get notified by OEX only of YOUR own 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. #InterSystems IRIS #Open Exchange 12 5 1 94
Article Robert Cemper · Sep 4 4m read IRIS in Docker for beginners The article was motivated by the 2025 September Article Bounty***************************************************************The principle of Docker is just convincing to me. Get a sandbox where you play and try whatever you want/need to do Once done. You drop it without leaving traces in your working environment This was the technical base for me to run about 700 reviews in OEX with almost no side effects (except those caused by myself). #Docker #InterSystems IRIS 12 3 5 140
Article Robert Cemper · Aug 3 1m read WARNING: Bug in IRIS Native API Reviewing my published packages, I identified a nasty bug in IRIS Native API #Java #Node.js #ObjectScript #Python #InterSystems IRIS 3 14 0 215
Article Robert Cemper · Jul 27 2m read Reviews on Open Exchange - #54 If one of your packages on OEX receives a review you get notified by OEX only of YOUR own 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 2 2 0 69
Article Robert Cemper · Jul 23 1m read Global-Inspector If you are investigating complex structured Globals this can becomea rather boring typing exercise. Different from Global Explorer inSystem Management Portal Global-Inspector allows a kind of drill-downto dig deeper and deeper by subscript levels.You also have the option to see the stored content or to show onlythe subscript structures.Globals storing SQL Tables are probably not so thrilling, but in SYSTEMspace you find real trees with completely different branches and twigs. #Caché #Ensemble #InterSystems IRIS Open Exchange app 3 1 0 65
Article Robert Cemper · Jul 15 2m read Reviews on Open Exchange - #53 If one of your packages on OEX receives a review you get notified by OEX only of YOUR own 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 2 0 0 43
Article Robert Cemper · May 26 2m read Reviews on Open Exchange - #52 If one of your packages on OEX receives a review you get notified by OEX only of YOUR own 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 2 1 0 50
Article Robert Cemper · May 2 1m read Reviews on Open Exchange - #51 If one of your packages on OEX receives a review you get notified by OEX only of YOUR own 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. #InterSystems IRIS #Open Exchange 1 0 0 64
Article Robert Cemper · Mar 28 2m read Reviews on Open Exchange - #50 If one of your packages on OEX receives a review you get notified by OEX only of YOUR own 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 made a major change and expect a changed review just let me know. #InterSystems IRIS #Open Exchange 5 1 0 79
Question Robert Cemper · Feb 3 Py fails in Win Terminal - fixed USER>do $System.Python.Shell() ERROR #5002: ObjectScript-Error: <OBJECT DISPATCH>Shell+16^%SYS.Python.1 *Failed to Load Python: Check documentation and messages.log, Check CPF parameters:[PythonRuntimeLibrary,PythonRuntimeLibraryVersion], #Embedded Python #InterSystems IRIS 0 9 0 220
Article Robert Cemper · Feb 3 3m read SQL Host Variables missing ? Host Variables are a rather common programming feature in many implementations of SQL. A recent question in DC made me aware that in IRIS, Caché, Ensemble, ... host variables just exist within embedded SQL > You can supply host variables for Embedded SQL queries only. < Related examples are included in the available Documentation This is a description for a workaround if you don't / can't use embedded SQL. #SQL #Caché #Ensemble #InterSystems IRIS Open Exchange app 12 0 0 229
Question Robert Cemper · Feb 1 keep only the COS routine object (cache object script) to preserve the source routine.mac Import from DC-PT, @Edilson Eberle Carvalho We have some *.mac routines and we need to preserve their source,as these routines have intellectual authorship and can only be used per sessionwith the right to use (they cannot be viewed or edited).The question: how to keep only the routine object in the IRIS namespace,without interfering with its execution? #InterSystems IRIS 1 2 0 96