go to post Robert Cemper · Jan 27, 2022 A serious problem I also struggled with.I think inside IRIS there is not much chance to get across the MAXSTRING limit.
go to post Robert Cemper · Jan 27, 2022 ??? OEX Conrests shows: Start on March 7th, 2022.I hope Feb. 7th is correct, ???
go to post Robert Cemper · Jan 25, 2022 Take care PUBLIC is a SQL Reserved Verb and may cause some troubles.https://openexchange.intersystems.com/package/migration-pg-iris-dataset?tab=reviews
go to post Robert Cemper · Jan 21, 2022 Hi Werner,The default of Namespace USER is to be mapped as Interoperability (aka ENSEMBLE) - enabled.If you create a new namespace, deselect the Interoperability-Enabled checkbox. You may of course also just delete Namespace USER and create a new one.OR remove the mapping directly from iris.cpf.
go to post Robert Cemper · Jan 21, 2022 Big THANKS to @Yuri Marx Pereira Gomes (getting red cheeks) You confirm, that my intention to pass along the accumulated experience works.And I'm glad I can contribute to this community which I had in mind (~ 15years back)but couldn't realize myself. So I have also to thank @Evgeny Shvarov and his team that made my "dream" true and successful.
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.
