go to post Robert Cemper · Feb 2, 2022 but it fails if the unpaired is < -9 as in the ref.example "-110,110,-38,-38,-62,62,-38,-38,-38" and doesn't stop
go to post Robert Cemper · Feb 2, 2022 NICE. but runs forever if there is no unpared. And why starting with -9 ?
go to post Robert Cemper · Feb 2, 2022 size = 65 return 0 if all pared; { 0 is excluded for pairing } ClassMethod Solve(o As %String) As %Integer { s y=$lfs(o) f i=1:1:$ll(y) s c=$li(y,i) ret:'$lf(y,-c) c q 0 }
go to post Robert Cemper · Feb 2, 2022 Special thanks for defining the clear rules and excluding 'dirty' tricks
go to post Robert Cemper · Feb 1, 2022 #1 convert both dates to $HOROLOG format and substract it # 2 use $system.SQL.Functions.DATEDIFF()
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
