the basic mechanic in ObjectScript is the LOCK command (https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=ITECHREF_lock) 
for persistent objects this mechanic is named Concurrency
check this context with lots of various cases and examples 
https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=GOBJ_concurrency
. https://docs.intersystems.com/iris20241/csp/docbook/DocBook.UI.Page.cls?KEY=GCOS_lockbasics

Hallo @Ditmar Tybussek  lange nix mehr gehört von dir !

See my article Using VECTORs in ObjectScript.
related to your code: 
Simple Set vector=.... doesn't work
it is       Set $VECTOR(vectorname,  pos,type)   very clear example
and type can never be changed 
position is less sensitive. 

In your case using SQL functíon TO_VECTOR() might be quite comfortable
as it does all the checks for you under cover.
i also used all-MiniLM-L6-v2 (as PY method) starting from  label sc3 in the example
in my OEX package Vector-inside-IRIS
LG. aus Wien
 

a personal hint:

• be as precise in your question as possible.

example (with shortened replies)
- how to run IRIS ODBC client install in a fresh container ?   >> use IRIS container as base  😕
- how to run IRIS ODBC client install in a NOT IRIS based container ? >> No idea, ask developer community 🤒
- how to connect to Cloud SQL from Apache Superset osing ODBC and TLS/SSL ?
>>> what I really has in mind.  (found it by accident)  
Reply is quite detailed It's the example from the announcement above  I'll try

minor simplification:
inserting my 77 char server address into the15 char Server-IP of Windows DSN caused me repeating problems.
k8s-45090081-a9b5a485-233c4dadf5-46cc35674de4c26d.elb.us-east-1.amazonaws.com

A real pain to verify
So I translated it to a real IP address using nslookup

SAMPLES>$nslookup k8s-45090081-a9b5a485-233c4dadf5-46cc35674de4c26d.elb.us-east-1.amazonaws.com
;  . . . .
Name:    k8s-45090081-a9b5a485-233c4dadf5-46cc35674de4c26d.elb.us-east-1.amazonaws.com
Address:  3.215.248.100

3.215.248.100
was working excellent and easy to check and to work with
 

see: https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=RGOT_complete

browser search "Extent Index"

$ZTRAP is pretty much the same idea as ONERROR that you find in
BASIC, VB, VBA, JavaScript  and some other old languages.  
a left over from M
 

in docker-compose.yml

change

command: --key /dur/key/iris.key

to

command: --key /dur/key/iris.key -b "sleep 2000" 

so the container starts but IRIS is not started
2000 is just some hang for your investigation (2000 sec)

in a 2nd session run

docker-compose exec iris bash

and start IRIS manually to see all details of what might be wrong
 

I share your suspicion on reserved Verbs.

You may try 

m.Name as "myName"

Or even

m.Name as "Name"

Just a guess from the  hip

first you need to install a valid DSN: Defining an ODBC Data Source on Windows
for PS you may take the same approach as described here

Wrap your SELECT in an Outer  SELECT LIST(...inner select ...)
try:

SELECTLIST(DIAGNOSE) FROM (
 SELECT MRDIA_.....->MRCID....
 FROM ......
 WHERE .....
 ORDERBY ......
)

What you describe is indeed named Global:
and the syntax could be  ^ehr.IP to follow your question.
It is visible over the whole namespace.
If you use ^%ehr.IP the % makes it available over all namespaces of your installation.

Set ^%ehr.IP="whatever you need" is creating it   
 

A quite interesting feature.
Did you take a look on how backup management is affected / involved by this design ? 
I just fail to imagine how to keep all this in synch.
e.g. if spread over several drives:
Are they backed up in total or in volume junks ?