Article Robert Cemper · Sep 17, 2020 4m read Native API for ObjectScript Demo The demo is based on the raw class descriptions.The data classes used are Address, Person, Employee, CompanyFor a more attractive demo, a JSONtoString method by ID was added. #API #ObjectScript #InterSystems IRIS 9 0 0 246
Article Robert Cemper · Sep 14, 2020 3m read IRIS Native API for ObjectScript It seems to me that for some reason this didn't make its way to the official documentationand seems to be rather unknown though implemented already in IRIS 2020.1 Thanks to @Dan Pasco I got a hint on the classes involved.I used the recommended sequence of how to use it. it is all directly taken from Class Reference and I just collected it to create a first overview. #API #InterSystems IRIS 10 1 2 513
Question Robert Cemper · Aug 30, 2020 How to Restart SMP server Caused by a conflict in the port assignment I get this entry in mesages.log and SMP doesn't respond: #System Administration #Caché #Ensemble #InterSystems IRIS 8 6 0 597
Article Robert Cemper · Aug 28, 2020 2m read Effective use of Collection Indexing and Querying Collections through SQL Triggered by a question placed by @Kurro Lopez recently I took a closer look at the indexing of collections.My simple test setup is a serial class and a persistent class with a list of this serial. #Indexing #SQL #Caché #Ensemble #InterSystems IRIS 8 5 1 441
Article Robert Cemper · Aug 3, 2020 3m read Global Scanning & Slicing In most cases, a global used by default storage has just 1 subscript level that represents the IDKEY.For an index-globals we may see 2 or more subscript levels.Arrays, or parent-child relationships or persistent classes extending a base data classare examples where we see more levels. Though all these globals are quite uniform. #Globals #ObjectScript #SQL #Caché #Ensemble #InterSystems IRIS 7 0 1 312
Article Robert Cemper · Aug 2, 2020 2m read Show Global by SQL SELECT Globals in Caché / Ensemble / IRIS are normally invisible over SQL accessThis example shows how to overcome this limit. #Globals #SQL #Testing #Tips & Tricks #Caché #Ensemble #InterSystems IRIS 9 1 2 733
Article Robert Cemper · Jul 29, 2020 5m read SQL for ^ERROR Global Standard error logs in IRIS / Caché / Ensemble are written global ^ERRORS.As this piece dates back some decades back to previous millennium its structureis far from the typical SQL storage structures. #Error Handling #Globals #Mapping #ObjectScript #SQL #Tips & Tricks #Caché #Ensemble #InterSystems IRIS 11 16 3 684
Article Robert Cemper · Jul 27, 2020 2m read ZPMshow, a helper for tired fingers The offer of ZPM is growing daily and the short names andacronyms of the offer are sometimes hard to understand andalso hard to type with my lazy fingers. So I decided to have a listing with the descriptions from the repository, split in short junks to avoid backscroll, controlled forward / backward scrolling, the option to select my packages by number, to install or uninstall with limited typing. It runs with do ^zpmshow A snapshot from the screen: #ObjectScript #InterSystems IRIS 12 0 0 289
Question Robert Cemper · Jul 21, 2020 List of Command Line Utilities ? where can I find a list of all command line utilities with a short description? #DevOps #System Administration #Caché #InterSystems IRIS 11 3 2 1,025
Question Robert Cemper · Jul 21, 2020 Intelligent Global Compare wanted I'm looking for some existing solutions to compare 2 global structures. - by subscripts- if subscripts match then by content. #Analytics #Globals #Caché #InterSystems IRIS 12 1 1 370