go to post Robert Cemper · Jan 31, 2022 set def=##class(%Dictionary.CompiledClass).%OpenId("Sample.Person.JSON") write def.SqlSchemaName Sample_Person write def.SqlTableName JSON
go to post Robert Cemper · Jan 31, 2022 example: set def=##class(%Dictionary.CompiledClass).%OpenId("oex.Dir") write def.SqlSchemaName oex write def.SqlTableName Dir
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 (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 ];
