I could imagine 2 variants:
You are CORRECT ,
In Caché/Ensemble SMP uses straightforward CSP and you have %session object and %request ...
I verified IRIS 2022.2 and 2022.3:
- SMP runs Queries differently and neither %session nor %request is visible
by variable » %inBackground = 1 it indicates working in background
and once completed the Job is gone, but SMP is still around
As a first step I would try to find out if your Trigger is running in the same process as your CSP
just writing $JOB with a $H into a test global. eg.:
set ^stefan($h,$j)="CSP" for CSP
set ^stefan($h,$j)="TRIGGER" for the trigger code
;;; or use
do LOG^%ETN() ; write to ^ERRORSAs @Enrico Parisi pointed out: IRIS.DAT is an independent structure
The link between file and Namespace is in the ConfigFile (??.CPF) in your install directory.
The file could be located anywhere.
MS Acess typically uses ODBC data sources.
By default, the ODBC35 driver for Cache/IRIS is installed at Cache/IRIS installation time.
You have to configure it (directly or from MS Access) with Namespace + SuperServer Port
Take care not to mix 32bit mode with 64bit mode depending on your Cache installation
I use the suggested common method for length calculation
/// write ##class(Golf.Task2).length()
ClassMethod length(
class = {$classname()},
method = "Build") As %Integer
{
#dim methodObj As %Dictionary.MethodDefinition
set methodObj = ##class(%Dictionary.MethodDefinition).IDKEYOpen(class, method)
quit methodObj.Implementation.Size
}
also in terminal:USER>p
s (b,h)="*" f L=f:-1:1 w ?L,b,! s b=b_h_h
F i=1:1:f K s,c S ($P(s," ",f-i+1),$P(c,"#",i*2))="" W s,c,!
65 ???
You are on the right path, I use deuw and see.png)
some differences grown by history
4 and 5 may contribute to the lastest nonsense of German Language Authoroties
that introduced sharp_S also in uppercase.
<we lived since ever without it and didn't miss anything>
Your case:
You can't change the collation of an existing Global
But you can apply a different collation before first use in SMP
to overwrite default collation of the DB
System > Configuration > Local Databases > Globals > New Global
So you set up a global ^TEMP3 with collation German3
and run MERGE ^TEMP3=^TEMP and have a new collation.
Some time back I set that to have different index collations for
German, Hungarian, Italian, French, Slovenian, ...
see my post Multi Language Sort
most likely a timeout.
That's me..png)
expression into :var stores the content of the expression into a local host variable var
in your case you seem to get from STRING(...) 2 expression stored in to variables CODE and VALUE
this construct is typical for embedded SQL
You should really read the docs in detail
LOAD DATA ......<filename>
'D:\Intersystem\IRISHealth\Mgr\' is just a directory, not a file
and you need all access rights
I would expect something like 'D:\Intersystem\IRISHealth\Mgr\tablename.txt'
Did you use $system.SQL.Shell() to launch it ?
I found this during the cleanup of old files.
Created when DeepSee was announced at some German Symposium ages ago..png)
if it's just for variables System Management Portal may do it.
Congratulations to all Winners !
I'm pleased to see some new names here. 
Looks like an encoding issue.
Encoding in Studio is most likely different from your terminal settings.
And phyton has no idea about your surface settings.
Run this line in Studio and in Terminal and you see what's happening.
Matching ends after the end of 7bit ASCII encoding.
f j=0:1:64 w ! f i=0:1:63 w $c(j*64+i)
The content of Column COMMENT is expected to be $LB() format.
The most likely reason is : this property contains some ages-old junk
This works:
SELECT
ID,
CPFName,
%INTERNAL(Comments),
Name, Product, SectionHeader, Version
FROM Config.ConfigFileCache for Windows (x86-64) 2018.1.7 (Build 721U)
I started a new repo with a WORKING template.
then took a copy of your classes in a valid directory structure
Class MC2022AOC.Day10 should be stored ic src/MC2022AOC/Day10.cls
You may clone this repo to continue. Anyhow Quality Check is happy now.
intersystems_iris_community/qck-WIT-AOC2022
repo: rcemper/qck-WIT-AOC2022
Alea iacta est !
The race is done. We see 3 leaders and I have checked the first repo.
Thanks to @Robert Barbiaux:
- His code passed successfully Code Quality
- And the checks with test data set 1 and set 2 are OK
Congratulations!
Merry Xmas to all members of the Community!
@Kevin An ,
I really appreciate your suggestion. For a long list of candidates,
BUT. with only 3..4 possible participants in the winning ranks the effort is acceptable.
So it provides for me a deeper insight into your creativity.
- AoC is the first filter >>> "outsourced"
- Code Quality is the second >>> "normalized and automated"
- Calculations + Results is the last. >>> by own hands for now.
I take this burden with pride.
Though this personal view shouldn't prevent anyone
to create a better template for NEXT year.
The final day of AOC is approaching.
It is still 1 day to reach the magic 50 stars.
I plan to take my last ranking on my morning (CET) of Dec.26
Good luck and Merry Xmas.
Test data + results on GitHub will be updated as I have them available.
It's the classic impedance mismatch:
String manipulation under covers! 
BIG THANKS to @Dmitry Maslennikov for your detailed analysis!
To me, this looks like Retro-Trip.
Back to NMP world (No Mouse Please) with Terminal, Telnet, Console Interface.
It's a big chance for a broad revival of all the old command line utilities
that are still around and working well. (some still using dot syntax).
And thanks also to @Guillaume Rongier to underline the motivation
- "breaking down the monolith"
- "make the product more modular"
Other industries have shown us what that piece-by-piece dropping means.
according to my info none of the top 9 are employed by ISC.
@Anastasia Dyubaylo can you pls. check this?
Hi folks !
It's just another week to finalize Advent Of Code 2022.
Though the ranking didn't change much recently there are still 14 exercises to be done.
- But keep in mind that the ranking is just the first hurdle to take.
- Next, your code in ObjectScript has to be provided in a public repo on GitHub
- Besides the formal verification with Code Quality (use the provided template)
also, the calculations will be verified with a neutral dataset that is not yours.
So good luck and happy coding.
Robert
but I found no .github/workflow/ as in the official template. also module.xml doesn't match the content.