go to post Robert Cemper · Feb 3, 2022 Big THANKS to the whole community for the interest and the trust in my contribution,Not to forget to thank the excellent support team and the fruitful cooperation within the community!
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.
