go to post Robert Cemper · Jan 22, 2023 I could imagine 2 variants: creating a "clone" of the CSP based "synchronous" Queries we know from C/E to have the unique session just using xDBC based tools such as Squirrel, DBeaver, WinSQL, ..... which is probably better since SMP mimics ODBC mode, but doesn't use real xDBC connection external xDBC provides a 1:1 connection as a terminal session would do.
go to post Robert Cemper · Jan 22, 2023 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 visibleby variable » %inBackground = 1 it indicates working in backgroundand once completed the Job is gone, but SMP is still around
go to post Robert Cemper · Jan 22, 2023 As a first step I would try to find out if your Trigger is running in the same process as your CSPjust 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 ^ERRORS
go to post Robert Cemper · Jan 21, 2023 As @Enrico Parisi pointed out: IRIS.DAT is an independent structureThe link between file and Namespace is in the ConfigFile (??.CPF) in your install directory.The file could be located anywhere.
go to post Robert Cemper · Jan 21, 2023 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 PortTake care not to mix 32bit mode with 64bit mode depending on your Cache installation
go to post Robert Cemper · Jan 20, 2023 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,!
go to post Robert Cemper · Jan 19, 2023 You are on the right path, I use deuw and see some differences grown by history sort ÄÖÜ + ß (sharp S) after Z as by ASCII sort Ä after A, Ö after O, Ü after U but before Z ignore trema. sort Ä=A, Ö=O, Ü=U no idea about ß 4 and 5 may contribute to the lastest nonsense of German Language Authorotiesthat 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 GlobalBut you can apply a different collation before first use in SMPto overwrite default collation of the DBSystem > Configuration > Local Databases > Globals > New Global So you set up a global ^TEMP3 with collation German3and run MERGE ^TEMP3=^TEMP and have a new collation.Some time back I set that to have different index collations forGerman, Hungarian, Italian, French, Slovenian, ...see my post Multi Language Sort
go to post Robert Cemper · Jan 18, 2023 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 VALUEthis construct is typical for embedded SQL
go to post Robert Cemper · Jan 18, 2023 You should really read the docs in detail LOAD DATA ......<filename> 'D:\Intersystem\IRISHealth\Mgr\' is just a directory, not a fileand you need all access rightsI would expect something like 'D:\Intersystem\IRISHealth\Mgr\tablename.txt' Did you use $system.SQL.Shell() to launch it ?
go to post Robert Cemper · Jan 17, 2023 from the command line you may start SQL shell > DO $SYSTEM.SQL.Shell()and then use LOAD DATA as described here LOAD DATA
go to post Robert Cemper · Jan 16, 2023 I found this during the cleanup of old files. Created when DeepSee was announced at some German Symposium ages ago.
go to post Robert Cemper · Jan 16, 2023 if it's just for variables System Management Portal may do it.
go to post Robert Cemper · Jan 14, 2023 Congratulations to all Winners ! I'm pleased to see some new names here.
go to post Robert Cemper · Jan 2, 2023 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)
go to post Robert Cemper · Dec 26, 2022 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.ConfigFile Cache for Windows (x86-64) 2018.1.7 (Build 721U)
go to post Robert Cemper · Dec 26, 2022 Hi @Mark Charlton I started a new repo with a WORKING template.then took a copy of your classes in a valid directory structureClass 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-AOC2022repo: rcemper/qck-WIT-AOC2022
