go to post Robert Cemper · Jan 20, 2022 typo in first (mailed) version: DO $SYSTEM.SQL.Shell() dot instead of colon.
go to post Robert Cemper · Jan 19, 2022 from bash or whatever run csession to log into your instance. then user>ZN "myNamespace" nsp>do $system.SQL.Shell() nsp>>select * from Ens_Util.Log where ConfigName='SFTPTo.HQ.SAFETRACE.DFT' AND Text LIKE '%Put Stream%' and TimeLogged LIKE '%2021-10-16%' and off it goes
go to post Robert Cemper · Jan 16, 2022 But you can install a 2nd (new version) Instance on your server in parallel and mount the OLD iris.DATjust as an additional DB. And then copy whatever you need.
go to post Robert Cemper · Jan 13, 2022 OK! I just learned from @Benjamin De Boe on DiscordLOAD DATAQ is a DDL statement!Not a SQL statement. So Goodbye to SQL-Functions, ClassMethod_Procedures, and whatever nice stuff.Therefore VALUES clause is just a borrowed syntax without deeper meaning! I start to doubt the advantage of this feature.
go to post Robert Cemper · Jan 11, 2022 if you have access to WRC you may ask for an evaluation license(also for community edition)
go to post Robert Cemper · Jan 10, 2022 SQL needs to write to a persistent element.A TRIGGER may work eventually if it runs BEFORE data validations - not sureOR you fiddle around the data type and do the conversion there in the Code Generator for ClassMethod OdbcToLogical to accept a 2nd format, :-((
go to post Robert Cemper · Jan 9, 2022 If the table is based on an IRIS Class (ii.e. not generated by DDL)You may try /// helper for input Property InputDate As %String; /// real used date Property MyDate As %Date [ SqlComputeCode = { set {*} =$ZDH({InputDate},4)}, SqlComputed, SqlComputeOnChange = InputDate ];
go to post Robert Cemper · Jan 9, 2022 in a normal SQL INSERT using TO_DATE('12/5/1948','DD/MM/YYYY') works inside VALUES()just a guess for LOAD DATA
go to post Robert Cemper · Jan 3, 2022 As you can project ANY ClassMethod as SQL PROCEDURE I see no obvious limit to your intention.Call yoru JAVA from IRIS with any of the available interfaces (or nodjs, or Python, or .....)inside a ClassMethod that you present them as SQL_PROCEDURE.
go to post Robert Cemper · Jan 3, 2022 Hi! though this looks like a nice feature it is not so useful if not portable andeven available in ZPM.I use since ~ever~ my 3..5 char abbreviated extensions in %ZLANG...*to add such abbreviations I have even created my helper to add it o the flyHelper for ObjectScript Language Extensions with OEX + Video And sorry where is the difference between :sql to ZSQL or zsql (insensible to any mix of case) ?In addition in %ZLANG* your shortcut can also be a multiline function.
go to post Robert Cemper · Dec 27, 2021 Correct: Your version is: Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2017.1 (Build 792U) Mon Mar 20 2017 19:19:52 EDTBackport of %JSON classes to Caché is not available
go to post Robert Cemper · Dec 26, 2021 All code is also visible in QualityCheck Tab Codehttps://community.objectscriptquality.com/code?id=intersystems_iris_community%2FAdventOfCode
go to post Robert Cemper · Dec 26, 2021 Whoever provided your Cache and Ensemble, 2018.1should be able to do it. If he has a contract
go to post Robert Cemper · Dec 26, 2021 you get access if your product has a service contract with ISCWRC = Worldwide Response Center
go to post Robert Cemper · Dec 25, 2021 2021-12-25 22:24:55 UTC - DC Leaderboard final updateOnly 4 of 22 registered community members have completed all 25 exercises and reached 50 stars My own contribution at pos. #3 was disqualified by using Embedded Python.
go to post Robert Cemper · Dec 25, 2021 Hi Nigel,The CSP shell is rather limited. As it is not a browser, not running any CSS or JS it is only usefulfor basic cases with static layouts but is unable to do any dynamic stuff as required by ZEN or jquery.It is really just for CSP in the original sense.
go to post Robert Cemper · Dec 25, 2021 YES, pre-release was available in the first days of Dec.So dropping a few days and converting to Embedded Python was worth the rewrite.Since this is the future.It's somehow strange that the most likely oldest participant took that path first.
