It works if you do it better than just copy/paste  from browser
See this: 
https://community.intersystems.com/post/basic-objectscript-not-working-linux-command-line#comment-197376 
and this:
https://community.intersystems.com/post/basic-objectscript-not-working-linux-command-line#comment-197371

, which approach would you take ?

I would try to use embedded Python to escape from <MAXSTRING>
cut it to reasonable pieces and use them in COS as far as necessary.

that's because the browser or this horrible web editor converts <tab> to <blank>
this is just core MUMPS style for writing .INT code

AUMHSCRTC:USER>a<tab>SET x=1
AUMHSCRTC:USER><tab>WHILE x<10 {
AUMHSCRTC:USER><tab>WRITE !," Looping",x
AUMHSCRTC:USER><tab>SET x=x+1
AUMHSCRTC:USER><tab>}
AUMHSCRTC:USER><tab>WRITE !,"DONE"

AUMHSCRTC:USER>do a

you are mixing things.
#1) working:
1.1 yo talk to login + authentication
1.2 you talk to command prompt that stores your code locally. 
#2) not working
 authentication from script is not supported, the rest goes nowhere
#3) not working examples
both assume that
3.1 you enter the code in Studio, VSCode, ...and COMPILE  it.
3.2 you call the compiled code from the command line

DATEDIFF only compares the YEAR numbers. So:
    write  $system.SQL.DATEDIFF("yy",$h-250,+$h)   >>>> 1
because of comparing 2021 to 2022
but it definitely is less than 1 year
and it depends on the actual day of the year 

       INSERT INTO Sample_Table.Accounts (Account, AccountName, Bank)
        Select '123456', 'AccountNameOne', 'BANK1'    union all
        Select '654321', 'AccountNameTwo', 'BANK2'
 

Details:  https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=RSQL_insert

Hi @Scott Roth !
from my ~260+ reviews, I can confirm to you that Docker provides just the vanilla platform for 
demonstration and prepares genal settings (eg.REST)  and shuffles demo data.
But in 98% of those cases, the effective code is installed by ZPM.  
And if ZPM is not installed there is one of those famous 1-liners to install it  (with enough privileges).

To me, docker-compose is just a comfortable way to mix up ports, and volumes, to integrate the container with the environment outside the container.
I'm rather sure our well known Docker Experts have a related cookbook ready for publishing
(there was just no contest to win a prize for it and make money)

The real info on what to copy where is mostly in Dockerfile., which is called by docker-compose.

in ObjectScript it might be

list("A","x")=""
list("B","y")=""
list("C","z")=""

and you pass it by reference 
do method(.list)
and consume is using $ORDER() or $QUERY()

and of course any TRIGGER on DELETE will give you more options
e.g. LOG^%ETN()   to dump the full call stack

Hi @Marcel den Ouden 

I did something similar a few years back for an ISC internal project.
I required 2 tables to achieve this
- mapping of the location to timezone code  (geographic coordinates are often misleading, STATIC)
- rules and offset from UTC (daylight Saving Y/N, the window when to apply,...) might be flexible
- $ZTZ is your friend and the Docs are really excellent also for special cases

A further complication is mobile use.
example:
- You go to Summit in Seattle. (UTC-7)
- you need to arrange a concall with a customer in Amsterdam (UTC+2) (CEST!)
- and meeting in Nov. (UTC+1)  back to normal time
- And you need to know the time zone used by your notebook (local or home or other?)

For the notebook, I used some JavaScript as the app was written in ZEN (10 yrs.back)
and it was mine and I could control it.
see more in my Article Global Time Management


 

From your description, it is obvious that you write ALL global streams just to default ^CacheStream.

To separate them you may set individual Globals for streaming (e.g depending on use-case)

Class %Library.GlobalBinaryStream has this parameter + property:

/// Default location: can be overridden at run-time
Parameter STOREGLOBALNAME = "^CacheStream"; /// Root is Global Location (name and top subscripts)

Property StoreRoot As %String(MAXLEN = 5000) [ InitialExpression = {..#STOREGLOBALNAME}, Private ]; Property rollback As %String [ MultiDimensional, Private ];

You can change this default using the method
Method %LocationSet(value As %String) As %Status
{
 Do ..Clear()
 Set ..StoreRoot=value,i%%Location=value
 Quit $$$OK
}
 

Default Samples.Person use the implicit ID.

You need to change or  write your own Method %IdSet or Define your own property as  ID

Suggestion:
add 

Property Val as Serials.Value;
in your main class
and
Class Serial.Value  Extends %SerialObject {
Property Single as %String;
Property Tsh as %String;
Property T4 as %String;
Property T5 as %String;
}  

in SQL you see it as columns 
Val_Single
Val_Tsh
Val_T4
Val_T5

$QUERY() needs a Global reference:

• ^je1("NotConfigured"   is OK
• node is just a local variable and not OK
• to use it you have to apply an indirection  >>> @node

I have edited my reply after the first send
and better use %node as indirection is context sensitive.

you get  <FILEFULL> in the directory  e:\eos\ and this is full. Whatever file you write there.
could E:\ be your journal location ? or temp ?
 

Between 2 servers you may use this:

• Background-Jobs-ECP  or
• ObjectScript-Over-ODBC  

set sc=rs.Execute("a")

You pass a paramter,
but there is no need for a parameter visible.  NO ? in query

try

set sc=rs.Execute()

Just an idea:
wouldn't CopyFromAndSave(source As %Stream.Object) be a better approach ??

Httprequest.EntityBody is a %GlobalBinaryStream object.
In your code I see

Do Httprequest.EntityBody.Write(mystring)

But no %Save()  to take care of completion and persistence of the object

Congrats!
By manual intervention, you managed to get your index out of sync with your date.
Check this Repairing your Index

Sorry the method is not yet available in 2014.1 you need a Rebuildindex (from SMP)