I think this should be the way to go: "New language translated  to COS"
And I'm sure it would be better than the ugly attempt to map COS into HTML as done in CSP   

Maks I fully support your position.
There are very few languages where you can run code written  40 yrs. ago with no modification !
That's what counts for customers.

You have other languages in parallel like MV or BASIC besides all the embedded things like &SQL(), &HTML(), &JS()..

But with same reasoning you may ask why is Java, JavaScript  or C, C# not changed?
Because you got GO, Angular, ..... to have attractive extensions.
COS has it's ZZ*, $ZZ* as extensions.  ( ZZ* ! )

Isn't this enough for thousands of developers that haven't asked for it nor have a need  for it?  

$system.SQL.Shell()  is bypassing ODBC Driver and talks directly to Caché Storage

an external query tool expects to get a MAXLEN by definition of ODBC  (ages back).
So this is a matter of backward compatibility.
Pls. check the grey hook left of ANSWER to confirm questions as done

Thx.

pls.  place this in a separate question to make it public to others

Hi Ben,

Thanks for keeping this. I lost my collection.

I remember so well how much fun we had making the icon for Hermes
- DeepSee2  (does anyone remember there was a DeepSee1 ?)
- HealthShare (getting the Aesculap snake in place)
 

for this cases a possible solution could be 

%Stream.Global has a FindAt method that could give you a position of  "\u00"

[Find the first occurrence of target in the stream starting the search at position. ]

http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?P...

But: if you are on the decoded stream all non printables are just single characters. No issue to cut it in pieces

• read your source stream in reasonable sized junks
• clean out what ever you need
• append it to a temporary stream
• loop on source until you hit AtEnd condition
• finally replace your source either by "copyFromSteam" method [temp -> source]
  or replace source stream reference by temp stream reference

I guess the whole code is shorter than this description.

I'd suggest not to touch the global under the source steam.

of course it makes sense!

but then you know which application is using it and can use the application's cleaning method / routine that takes care of all kind of dependencies:
I remember well times when routines used to start with  KILL ^CacheTemp*($JOB)
I expected over time most applications are using PPG  (^||myGlobal...) to avoid this. Or have a Clean-Up.

It's the task of the application that uses ^CacheTempUser.*  to take care of the housekeeping.
I found no traces that it belongs to Caché System Management and Operation.

So for a first check if this  is the only issue just throw the full string into a $TRANSLATE
$tr(jsonstring,$c(26)) and whipe it out.

e.g.
ZNAMESPACE "%SYS" 

be careful !

Hi Evgeny,

IF you can afford a short OFFLINE state:

#5)  dismount DB / copy of cache.dat to a fast local device / remount it
      move the copy in a secure place: #2, #1

ELSE IF you have to remain online all the time:
#3)  on fast local device + move backup in secure place by #2,#1
 

NEVER #4) a fair chance for massive inconsitency

Robert
[semper fidelis]