go to post Robert Cemper · Feb 2, 2022 this works unlimited but has no exit if none unmatched foundmethod length = 64,and it shows only the abs. value 38 instead of -38 s y=$lfs(o) f i=1:1 s a=$lf(y,i),b=$lf(y,-i) ret:a+b&'(a*b) i
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.
