Question Robert Cemper · Feb 3 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 87
Article Robert Cemper · Jan 30 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 118
Article Robert Cemper · Jan 30 2m read JSONfile-to-Global #1 The similarity between JSON objects + arrays and Globals in IRIS or Caché is evident.With small and medium size JSON objects navigation across %Dynamic Objects is comfortable.But with large and/or deep cascaded objects it becomes a challenge. The presented tool offers 3 variants loading an already existing %Dyamic object or Array into a global of your choice loading a %Stream containing a JSON object into a global of your choice loading an external File containing a JSON object into a global of your choice #Globals #JSON #Tips & Tricks #Tools #InterSystems IRIS #Open Exchange 6 1 2 149
Article Robert Cemper · Jan 27 1m read Global-Streams-to-SQL #3 Seeing results in SMP or Terminal If you run the suggested queries from Terminal in SQL shell you see: #Debugging #Globals #JDBC #ODBC #SQL #Tips & Tricks #Tools #Caché #Ensemble #InterSystems IRIS 1 0 1 102
Article Robert Cemper · Jan 23 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 usesa Process Private Global (PPG) as Temporary storage.using SELECT * FROM RCC.gstreamT WHERE RCC.useT('^jpgS')=1 and similar. #Debugging #Globals #JDBC #ODBC #SQL #Tips & Tricks #Tools #Caché #Ensemble #InterSystems IRIS 2 0 0 73
Article Robert Cemper · Jan 23 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 thisSpecial thanks to @Oliver Wilms for the inspiration for this tool. #Debugging #Globals #JDBC #ODBC #SQL #Tips & Tricks #Tools #Caché #Ensemble #InterSystems IRIS 6 1 1 188
Article Robert Cemper · Dec 19, 2022 2m read Reviews on Open Exchange - #23 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. #InterSystems IRIS #Open Exchange 0 0 0 64
Article Robert Cemper · Dec 4, 2022 2m read Reviews on Open Exchange - #22 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. #InterSystems IRIS #Open Exchange 0 0 0 69
Article Robert Cemper · Nov 28, 2022 2m read Reviews on Open Exchange - #21 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. #InterSystems IRIS #Open Exchange 2 0 0 133
Article Robert Cemper · Nov 25, 2022 2m read Reviews on Open Exchange - #20 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. #InterSystems IRIS #Open Exchange 3 0 0 196