Online Demo added:
- Log in to post comments
Online Demo added:
FOR loop does not accept a quit with argument.
ERROR: CodeGolf.CHK.cls(7) :QUIT with arguments not allowed here c
but return is 5 chars more
possible but not likely: your friendly WIN Firewall blocks port 1972 in both directions)
You could check in mgmt Portal MEMORY at the Bottom Super server Port
The next chance is that you run out of licenses. Also available in MgmPortal.
(CSP/ZEN can be a huge license eater)
#1
Caché Studio can't access IRIS for version reasons. Reverse IRIS studio can sometimes.
Better run separate versions.
#2
Studio requires access to SuperServerPort. Actual 1972 previous was 51773.
if your IRIS runs in a Docker Container check the port mapping .
closed
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!
GREAT ! covers all situations.
this works unlimited but has no exit if none unmatched found
method 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
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
NICE. but runs forever if there is no unpared.
And why starting with -9 ?
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
}and you get 0 if numbers are paired !
Special thanks for defining the clear rules and excluding 'dirty' tricks ![]()
#1 convert both dates to $HOROLOG format and substract it
# 2 use $system.SQL.Functions.DATEDIFF()
Welcome on board !![]()
set def=##class(%Dictionary.CompiledClass).%OpenId("Sample.Person.JSON")
write def.SqlSchemaName
Sample_Person
write def.SqlTableName
JSONexample:
set def=##class(%Dictionary.CompiledClass).%OpenId("oex.Dir")
write def.SqlSchemaName
oex
write def.SqlTableName
Dir
A serious problem I also struggled with.
I think inside IRIS there is not much chance to get across the MAXSTRING limit.
??? OEX Conrests shows: Start on March 7th, 2022.
I hope Feb. 7th is correct, ???
factor 64.7 times faster ![]()
Take care PUBLIC is a SQL Reserved Verb and may cause some troubles.
https://openexchange.intersystems.com/package/migration-pg-iris-dataset?tab=reviews
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.
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.
typo in first (mailed) version: DO $SYSTEM.SQL.Shell()
dot instead of colon.