Article Brendan Bannon · Jul 15, 2021 6m read Embedded SQL new in InterSystems IRIS Benjamin De Boe wrote this great article about Universal Cached Queries, but what the heck is a Universal Cached Query (UCQ) and why should I care about it if I am writing good old embedded SQL? In Caché and Ensemble, Cached Queries would be generated to resolve xDBC and Dynamic SQL. Now i #SQL #InterSystems IRIS 9 1 1 819
Article Brendan Bannon · Dec 27, 2016 8m read The Art of Mapping Globals to Classes (5 of 3) Mapping Examples Clearly if you have a fourth article in the trilogy you need to go for the money grab and write the fifth, so here it is! #Mapping #Object Data Model #SQL #Caché 9 15 1 2.5K
Article Brendan Bannon · Dec 27, 2016 8m read The Art of Mapping Globals to Classes (4 of 3) The Art of Mapping Globals to Classes (4 of 3) The forth in the trilogy, anyone a Hitchhikers Guide to the Galaxy fan? If you are looking to breathe new life into an old MUMPS application follow these steps to map your globals to classes and expose all that beautiful data to Objects and SQL. If the above does not sound familiar to you please start at the beginning with the following: The Art of Mapping Globals to Classes (1 of 3) #Globals #Mapping #Object Data Model #SQL #Caché 5 7 0 2.1K
Article Brendan Bannon · Nov 29, 2016 7m read The Art of Mapping Globals to Classes (3 of 3) The Art of Mapping Globals to Classes (3 of 3) If you are looking to breathe new life into an old MUMPS application follow these steps to map your globals to classes and expose all that beautiful data to Objects and SQL. If the above does not sound familiar to you please start at the beginning with the following: The Art of Mapping Globals 1 #Globals #Mapping #SQL #Caché 8 9 0 1.8K
Article Brendan Bannon · Oct 27, 2016 2m read New WRC Customer Interface New WRC Customer InterfaceCome check out the new WRC interface we have made available to supported customer. Some of the new features available to you are: Organization Dashboard – gives an overview of your organizations activity for this year #Caché 9 9 0 1.1K
Article Brendan Bannon · Sep 1, 2016 9m read The Art of Mapping Globals to Classes (2 of 3) The Art of Mapping Globals to Classes (2 of 3) If you are looking to breathe new life into an old MUMPS application follow these steps to map your globals to classes and expose all that beautiful data to Objects and SQL. This example is going to cram in 4 or 5 different things beyond what was covered in Part 1 #Globals #Mapping #SQL #Caché 10 2 0 2.5K
Article Brendan Bannon · Aug 29, 2016 7m read The Art of Mapping Globals to Classes 1 of 3 The Art of Mapping Globals to Classes 1 of 3 Looking to breathe new life into an old MUMPS application? Follow these steps to map your existing globals to classes and expose all that beautiful data to Objects and SQL. #Best Practices #Globals #Mapping #SQL #Caché 22 26 11 5.7K
Article Brendan Bannon · Nov 9, 2015 1m read Cache SQL Storage Mapping The attached zip file contains a bunch of examples of Cache SQL Storage mappings that I have done over the years.If you have existing globals and want to expose them via Objects or SQL you need to setup Cache SQL Storage mapping. If you do not see an example that helps with your case send me an example and I can help you out. #Code Snippet #System Administration #Caché 2 0 0 1.1K
All posts
All posts
All posts