New post
AllAccepted answers
Robert Cemper · Dec 20, 2021

I see!  And I feel it is right.
Therefore I suggested using a different private leaderboard about 2 weeks ago
where you have to request the access code from Developer Community Managers.
Instead of this public published access key. It could be kind of a registration.
And with 23 actives ist's not much extra effort + no need for recalculation and filtering.

Eventually, this may happen next year.
Though technically It may still be possible this year it's just bad taste
to change rules if you dislike the results during the game.

The next challenge is that ISC employees are excluded from prizes.
which requires a further step of filtering.  Though I have this Info, I didn't apply. 

Robert Cemper · Dec 16, 2021

As your properties are NOT Calculated then there is a Storage Entry (check Storage section) 
they are persisted and not just there on run-time

  • copy the class including Storage Definition !!!
  • set class  Parameter MANAGEDEXTENT  = 0;  to allow access to original Globals
  • remove SqlCompute*  from the Properties LastModified*   ; to make it normal Properties
  • now write to these properties whatever you need to do by object access or SQL  
Robert Cemper · Dec 15, 2021

The SQL statement you pass is an ordinary string.
So with LongString enable it is about 3,4MB  and of course I have never tried to write so
much in a single string. That's boring and hard to type.
If you mean running long it's probably just useful on the command line or background.
an ordinary connection to over ODBC/JDBC or HTTP in browser will most likely time out. 
What type of LONG are you referring to ?

Robert Cemper · Dec 11, 2021

Watching the daily results of our private leaderboard I did some observations:

  • the number of registered participants has grown since start from 68 to 93, 82 no surprise with the published code
  • actually, only 33 participants have collected  points and stars
  • I downloaded the actual ranking as JSON file into a local table 
  • I could identify only 17  22 names from DC that I flagged DC for our ranking
  • if I missed you pls. let me know your identity in AoC by DC mail  to add your DC flag

Date:  2021-12-27 08:53:47 UTC

Rank    DC      stars   score   name
1       1       50      4087    Kevin An
2       1       50      4026    Yuval Golan
3       1       50      4056    rcemper     disqualified by using Embedded Python
4       1       50      3798    ISC Jacques HUSER
------------------------------------------------ all completed
5       1       41      2901    Bert Sarens
6       1       36      2825    Oliver Wilms
7       1       36      2689    dspools
8       1       36      2683    Ivo ver eecke
9       1       28      2060    Tim Leavitt
10      1       22      1775    Fabian
11      1       17      1273    rhodery
12      1       18      1265    Shamus Clifford
13      1       18      1230    CrashAvery
14      1       16      1149    TylerFeldhege
15      1       15      1147    Sergei Shutov (Banksia Global)
16      1       11      764     José Roberto Pereira Junior
17      1       9       599     jackpto
18      1       6       386     NjekTt
19      1       5       307     Stuart Byrne
20      1       4       267     goran7t
21      1       2       148     David Hockenbroch
22      1       2       116     Evgeny Shvarov
------------------------------------------------ DC members
23              50      4145    Steven Reiz
24              32      2584    Navæéd Ålæm
25              28      2271    Carter Bourette
26              11      804     jonasvandervennet
27              11      768     @leeto
28              8       548     Paul Langelaan
29              6       416     alex2008alex
30              1       57      maxisimo

Instead of a daily reply, I plan just to update this reply once a day

Robert Cemper · Dec 10, 2021

Sure!  very condensed

  • set cls=##class(%Dictionary.ClassDefinition).%OpenId("<pkg>.<classname>")
  • set met=cls.Methods.GetAt(1)  ; may need some search
  • set imp=met.Implementation   ; a GlobalChar.Stream
  • write imp,OutputToDevice()

or you jump to the Method directly

  • set met=##class(%Dictionary.MethodDefinition).%OpenId("<pkg>.<classname>||<methodname>")

And these classes have tons of params to set or clear by specific methods

Robert Cemper · Dec 4, 2021

I'm not so convinced that such a converter never existed.
Probably in past  ~20yrs+ back when the improved readable syntax
came in place at the beginning of the millennium.
And taking this time gap the engineers of such tools are
most likely not available anymore in whatever sense. 

Otherwise it is still working and used in system routines like
%R.int, %RI.int, %RIMF.int, %RO.int, %ROMFOLD.int, %ROU.int, %RSET.int, ....

Robert Cemper · Dec 3, 2021

You expect something rather impossible.
every temporary SQL query result, every Temp.Stream all PPG (^||glob  ) reside in CACHETEMP for all Namespaces and every process.
What you ask for would require ALL simultaneously running processes to remove their related contents.

I fact this means not just stopping all processes but forcing them to terminate.
in other words to shut down Caché   BTW. it's the same for IRIS.