Question Robert Cemper · Mar 11, 2022 JOB command fails with Embedded Python It sounds strange though it's embarrassing. I have a class with ClassMethods written in ISOS and Embedded Python. The ClassMethods written in ISOS start in the Background as usual. No problems But my #Embedded Python #ObjectScript #InterSystems IRIS 1 4 0 401
Article Robert Cemper · Mar 8, 2022 2m read ePython - mixed or pure ? You may have seen my series of articles on GlobalToJSON closing with Embedded Python.And to me, Embedded means inside a Class and not PEX or other external variants.The first variants showed that ePy is not an ultimate requirement. ISOS/COS may do it as well.Here I try to position ePy inside IRIS. #Embedded Python #Globals #ObjectScript #InterSystems IRIS 6 1 0 360
Article Robert Cemper · Feb 25, 2022 7m read GlobalToJSON-embeddedPython-pure#3 In my article I described the work using iris.gref .As the official documetation is rather slim on the subject it was necessary to dig into it.Using the power of Python I was able to detect what I needed but was hidden.I decided to share this with you. pydoc did the magic. #Embedded Python #Globals #InterSystems IRIS 3 0 1 265
Article Robert Cemper · Feb 22, 2022 2m read Reviews on Open Exchange - Feb.2022 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. New with this edition:Reviews by other members of the community are marked by * in the last column. #Open Exchange 4 2 0 223
Article Robert Cemper · Feb 9, 2022 2m read GlobalToJSON-embeddedPython-pure#2 This package was triggered by the extra bonus points in the contest for writing the examplein embedded Python only. Therefore PURE #Embedded Python #Globals #JSON #InterSystems IRIS 1 0 0 379
Article Robert Cemper · Feb 9, 2022 2m read GlobalToJSON-embeddedPython#2 I will give you some additional information on my first embedded Python package.it is written as a mix of python and ObjectScript to take the best of both worlds. #Embedded Python #Globals #JSON #ObjectScript #InterSystems IRIS 1 0 0 239
Article Robert Cemper · Feb 8, 2022 1m read GlobalToJSON-embeddedPython-pure I have created a package to export a Global into JSON object file and to re-create it by reloading from this file embeddedPython refers to the new available technologies. It should be understood as a learning exercise of how to handle the language interfaces. Only Global nodes containing data are presented in the generated JSON file.Differently from the previous example, this one is using embedded Python only, no ObjectScript. Therefore PURE #Embedded Python #Globals #JSON #Python #InterSystems IRIS Open Exchange app 8 2 0 611
Article Robert Cemper · Feb 7, 2022 1m read GlobalToJSON-embeddedPython I have created a package to export a Global into JSON object file and to re-create it by reloading from this file embeddedPython refers to the new available technologies. It should be understood as a learning exercise of how to handle the language interfaces. Only Global nodes containing data are presented in the generated JSON file. #Embedded Python #Globals #JSON #InterSystems IRIS Open Exchange app 2 2 0 419
Article Robert Cemper · Jan 30, 2022 2m read My Reviews on Open Exchange - Jan.2022 If one of your packages on OEX receives a review you get notified by OEX only on YOUR package.It reflects my experience with the status I found at the time of my review.It is kind of a snapshot and might have changed meanwhile. #Open Exchange 5 5 0 232
Article Robert Cemper · Jan 24, 2022 1m read GlobalToJSON-Compact I have created a package that offers a utility to load a Global into JSON object and reverse to create a Global from this type of JSON object. Compact refers to the structure created.Globals nodes are included with data for a fast data load. But also the related code is quite compact. #Globals #JSON #InterSystems IRIS Open Exchange app 5 3 0 417
Article Robert Cemper · Jan 24, 2022 2m read GlobalToJSON-Efficient I have created a package that offers a utility to load a Global into JSON object and reverse to create a Global from this type of JSON object. Efficient refers to the structure created.Only Globals nodes containing data are presented in the generated JSON object. #Globals #JSON #InterSystems IRIS Open Exchange app 4 2 0 507
Article Robert Cemper · Jan 24, 2022 1m read GlobalToJSON-Academic I have created a package that offers a utility to load a Global into JSON object and reverse to create a Global from this type of JSON object. Academic refers to the structure created.Each logical node of the Global is presented separately with all its descendants.Even if they don't contain any stored data. #Globals #JSON #InterSystems IRIS Open Exchange app 2 1 0 363
Question Robert Cemper · Jan 12, 2022 SQL LOAD DATA FROM FILE - limits in VALUE clause ? II try to explore the new SQL LOAD DATA feature in SQL comparing it to SQL INSERT I'm stuck at this point: INSERT INTO <table> (columns...) VALUES (.....)allows having not just simple column references but also ALL Standard SQL FUNCTIONS (at least)example: INSERT INTO Test (ShortName,DOB) VALUES (SUBSTRING(Name,1,4),TO_DATE(displayDate,'MM-DD_YYY')) This works perfectly. BUT the same VALUE clause applied to LOAD DATA fails in various ways: #SQL #InterSystems IRIS 1 3 0 297
Article Robert Cemper · Jan 2, 2022 3m read DB Migration using SQLgateway Thanks to @Yuri Marx we have seen a very nice example for DB migration from Postgres to IRIS.My personal problem is the use of DBeaver as a migration tool.Especially as one of the strengths of IRIS ( and also Caché) before is the availability of theSQLgateways that allow access to any external Db as long as for them an access usinig JDBC or ODBC is available. So I extended the package to demonstrate this. #Best Practices #Data Import and Export #Docker #SQL #InterSystems IRIS Open Exchange app 11 3 2 823
Article Robert Cemper · Dec 27, 2021 2m read My Reviews on Open Exchange - Dec.2021 If one of your packages on OEX receives a review you get notified by OEX only on YOUR package.So @Evgeny Shvarov suggested publishing my monthly summary of my reviews here in DC.It reflects my experience with the status I found at the time of my review. #Open Exchange 6 0 0 428
Article Robert Cemper · Dec 25, 2021 2m read AOC2021-rcc After >40 years of writing in-countable lines of code in M*/COS/ISOS (and a bunch of archaic languages)I decided for myself to set a strong signal for the future. We have Embedded Python available(still pre-release)! I just felt it as a sacrilege to ignore this excellent NEW opportunity andstay with the old sermon that I had used for decades. #Docker #Embedded Python #InterSystems IRIS Open Exchange app 11 0 0 408
Article Robert Cemper · Nov 30, 2021 2m read My Reviews on Open Exchange - Nov. 2021 If one of your packages on OEX receives a review you get notified by OEX only on YOUR package.So @Evgeny Shvarov suggested publishing my monthly summary of my reviews here in DC.It reflects my experience with the status I found at the time of my review. #Open Exchange 6 7 0 277
Article Robert Cemper · Nov 26, 2021 13m read Traditional Debugging in ObjectScript Finding errors in your code or examining unexpected behavior is the main purpose of DebuggingI will try to refresh the traditional tools away from the helpers you have in Studio, VScode, Serenji, ....to the basics which have been there before your preferred EDI used it in the background. #Other 19 10 3 1.5K
Article Robert Cemper · Oct 31, 2021 2m read My Reviews on Open Exchange - Okt.2021 If one of your packages on OEX receives a review you don't get notified by OEX only on YOUR package.So @Evgeny Shvarov suggested publishing my monthly summary of my reviews here in DC.It reflects my experience with the status I found at the time of my review. #Open Exchange 3 1 0 194
Article Robert Cemper · Oct 12, 2021 2m read Generating OFX [V1] Just in case you never heard about OFX beforeV1 was an attempt to create a dedicated SGML for banking and ignoring XML. Details.It evolved to XML but not for M$ MONEY. Today we would use JSON for similar tasks. #Other 5 4 0 510