from bash or whatever run csession to log into your instance. then
user>ZN "myNamespace"
nsp>do $system.SQL.Shell()
nsp>>select * from Ens_Util.Log where ConfigName='SFTPTo.HQ.SAFETRACE.DFT' AND Text LIKE '%Put Stream%' and TimeLogged LIKE '%2021-10-16%'
and off it goes
But you can install a 2nd (new version) Instance on your server in parallel and mount the OLD iris.DAT
just as an additional DB. And then copy whatever you need.
Thanks for the clarification.
So I have some hope
OK! I just learned from @Benjamin De Boe on Discord
LOAD DATAQ is a DDL statement!
Not a SQL statement.
So Goodbye to SQL-Functions, ClassMethod_Procedures, and whatever nice stuff.
Therefore VALUES clause is just a borrowed syntax without deeper meaning!
I start to doubt the advantage of this feature.
CONGRATULATIONS !!
It's you that keep DC moving fast! 
if you have access to WRC you may ask for an evaluation license
(also for community edition)
SQL needs to write to a persistent element.
A TRIGGER may work eventually if it runs BEFORE data validations - not sure
OR you fiddle around the data type and do the conversion there in the Code Generator for ClassMethod OdbcToLogical to accept a 2nd format, :-((
If the table is based on an IRIS Class (ii.e. not generated by DDL)
You may try
/// helper for input
Property InputDate As %String;
/// real used date
Property MyDate As %Date [ SqlComputeCode = { set {*} =$ZDH({InputDate},4)},
SqlComputed, SqlComputeOnChange = InputDate ];in a normal SQL INSERT using TO_DATE('12/5/1948','DD/MM/YYYY') works inside VALUES()
just a guess for LOAD DATA
As you can project ANY ClassMethod as SQL PROCEDURE I see no obvious limit to your intention.
Call yoru JAVA from IRIS with any of the available interfaces (or nodjs, or Python, or .....)
inside a ClassMethod that you present them as SQL_PROCEDURE.
Hi! though this looks like a nice feature it is not so useful if not portable and
even available in ZPM.
I use since ~ever~ my 3..5 char abbreviated extensions in %ZLANG...*
to add such abbreviations I have even created my helper to add it o the fly
Helper for ObjectScript Language Extensions with OEX + Video
And sorry where is the difference between :sql to ZSQL or zsql (insensible to any mix of case) ?
In addition in %ZLANG* your shortcut can also be a multiline function.
WOW !! GREAT !
Correct: Your version is:
Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2017.1 (Build 792U) Mon Mar 20 2017 19:19:52 EDT
Backport of %JSON classes to Caché is not available
All code is also visible in QualityCheck Tab Code
https://community.objectscriptquality.com/code?id=intersystems_iris_community%2FAdventOfCode
Whoever provided your Cache and Ensemble, 2018.1
should be able to do it. If he has a contract
you get access if your product has a service contract with ISC
WRC = Worldwide Response Center
2021-12-25 22:24:55 UTC - DC Leaderboard final update
Only 4 of 22 registered community members have completed all 25 exercises and reached 50 stars
My own contribution at pos. #3 was disqualified by using Embedded Python.
Hi Nigel,
The CSP shell is rather limited. As it is not a browser, not running any CSS or JS it is only useful
for basic cases with static layouts but is unable to do any dynamic stuff as required by ZEN or jquery.
It is really just for CSP in the original sense.
YES, pre-release was available in the first days of Dec.
So dropping a few days and converting to Embedded Python was worth the rewrite.
Since this is the future.
It's somehow strange that the most likely oldest participant took that path first.
Completed Solution:
Repository: https://github.com/rcemper/AoC2021-rcc
Description & Quality status: https://community.intersystems.com/post/aoc2021-rcc
Oh, dear! Dismounting IRISLIB is probably the worst you can do to destroy the whole system.
It's like removing the heart from your body. You shouldn't even think of it
THX ! Excellent tool!
Answer is sent.
Dear Iryna, I just prepare Xmas. So it may take some time for the reply.
not blocked and working as expected in
IRIS for Windows (x86-64) 2021.1 (Build 215U) Wed Jun 9 2021 09:39:22 EDT
.png)
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.
Interesting. How actual is your JSON input. ?
I download the same JSON file with the "local_score" from AoC
Update my table daily and sort it by( DC desc , score desc) every night. (see timestamps)
But your scores do not match AoC but deviate from AoC in both directions from last night's input.
(eg. yours by ~1000 pts minus ? )
2021-12-18 22:01:42 UTC - DC Leaderboard updated
This Management Team is exceptional! Thank you all!
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