Similar to previous years I will provide the results of our private leaderboard 

• It will sort by published ranking but separate DC members from "guests"
• The matching of DC members is a manual task 
• if I missed you pls. let me know your identity in AoC by DC mail  to add your DC flag
• due to private issue my updates might show delays sometimes
• 2 test sets with results are available on OEX: AoC2024-test
• I just added a column to show completion of parts in the exercises
  • -  no part
  • 1 only part 1  (silver star)
  • 2 only part 2 (another silver star)
  • 3 1+2 both parts completed (gold star) 

DCrank  AOCrank Scores  Stars   ok%     ----- Code Parts OK -----       Name
0       ---     ----    ----    ---     ----*----*----*----*----*       --- DC Members ---
1       2       1192    8       16      3333---------------------       maxymczech
2       3       1175    8       16      3333---------------------       Jani Hurskainen
3       5       1173    8       16      3333---------------------       Oskari Kosonen
4       7       1156    8       16      3333---------------------       Ivo ver eecke
5       8       1126    8       16      3333---------------------       Keith Avery
6       15      851     6       12      333----------------------       rhodery
7       16      849     6       12      333----------------------       JFerreB
8       17      829     6       12      333----------------------       Peter Zubiago
9       18      827     6       12      333----------------------       TylerFeldhege
10      19      549     4       8       33-----------------------       Oliver Wilms
11      21      413     3       6       31-----------------------       Chris Marais
12      ---     ----    ----    ---     -------------------------       --- ISC internals ---
13      11      1098    8       16      3333---------------------       TestSet 1
14      13      1090    8       16      3333---------------------       TestSet 2
15      ---     ----    ----    ---     -------------------------       --- unknow in DC ---
16      1       1204    8       16      3333---------------------       Dominik Znidar
17      4       1174    8       16      3333---------------------       Jarjar 314
18      6       1163    8       16      3333---------------------       Joaquin Derrac Rus
19      9       1117    8       16      3333---------------------       Abdul
20      10      1103    8       16      3333---------------------       Sloan Kanaski
21      12      1093    8       16      3333---------------------       (anonymous user #4293990)
22      14      884     6       12      333----------------------       Chhayank Warad
23      20      415     3       6       31-----------------------       Gary Nguyen
 
24 Rows(s) Affected
 
UTC 2024-12-04 18:19:30
EST 2024-12-04 13:19:30
 

My guess:

• It was the WINNER of the video contest: https://www.youtube.com/watch?v=ZW5_Un0sYUw
• Also with no refence to video or article on OEX  https://openexchange.intersystems.com/package/DNA-sequence-Gene-finder  

no need for this COPY
if your docker-compose.yml contains

    volumes:
      - ./:/home/irisowner/dev
 

• .MAC  and much more .INT  are an almost 1:1 image of the runtime .OBJ code
• they get implicitely compiled by ZSAVE command
• while any .CLS gets first stored with a lot of internal parameters where XML is faster than UDL
• then it's translated to .INT(at least) including all extra params,  
• and inherited pieces and other features for comfort 
• and then compiled as any other .INT for the final .OBJ 

So comparing .CLS  to .MAC/.INT is like comparing a goat to the final cheese you buy.

A few questions:

• my local IPv4 address in the ODBC connection
  • in ODBC you have to specify the IP address of the Caché server 
  • there you create the connection FROM YOUR local server
  • by default there's no connection outgoing from Caché
  • No need for your local IP - eventually for some firewalls
• enabling remote access 
  • if you have username + PW from Caché you should have access
  • only some firewalls on server or client may block you
• more important: what OS do you run on server and client ?    
• and what type of connection do you try to establish ?  Web, SuperServer, Terminal, ... ?

To get the property position dynamically by program you may use this ClassMethod
 

ClassMethod PropSeq(classname As %String = "", propname As %String = "")
   As %String [ SqlProc ]
{
    if classname="" set classname=..%ClassName(1)
    set pos=0
    &sql(
        SELECT SequenceNumber INTO :pos 
        FROM %Dictionary.CompiledProperty
        WHERE transient=0
        AND parent=:classname
        AND name=:propname
    )
    if SQLCODE set pos="-1;"_SQLCODE
    quit pos
}

a somewhat 'dirty' approach

select ID, Name_GivenName from Demo.DemoPatient 
where FOR SOME %ELEMENT(Demo.DemoPatient.Aliases) ($LISTFIND(%value,'Twain')>0)

advantage - no need to know the structure of your serial class
risk - false positives for unexpected coincidences.  eg. Washington, John, ...

This article is focused on indexing, though it shows the principle of the SQL query
Effective use of Collection Indexing and Querying Collections through SQL
 

it applies to any code in ObjectScript

start here in docs

BIG THANKS!
That soved the problem

It's a shame that the owner of the package didn't react to the ISSUE on Github or OEX for 3 months

run

USER > zn "%SYS"
%SYS > ZLOAD JOURNAL
%SYS > Print

in WebTerminal you just get NOTHING
in normal terminal and iterm  you see the code  

@Mario Sanchez Macias  You missed the point.
The essential functionality is to have a total autonomous partition to work in.
It was never named so, but it is the real Shell for ObjectScript and its predecessors for >50 years !

THX