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
go to post Robert Cemper · Dec 25, 2022 Now also the Leader of our ranking has completed Thanks to @Kevin.An- His code passed successfully Code Quality- And the checks with test data set 1 and set 2 are OKCongratulations!
go to post Robert Cemper · Dec 25, 2022 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 OKCongratulations! Merry Xmas to all members of the Community!
go to post Robert Cemper · Dec 24, 2022 @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 anyoneto create a better template for NEXT year.
go to post Robert Cemper · Dec 24, 2022 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.26Good luck and Merry Xmas.Test data + results on GitHub will be updated as I have them available.
go to post Robert Cemper · Dec 23, 2022 I have published 2 sets of test data on GitHub with results verified by AoC.You may use it to check the independency of your code from specific input.That's what I will use for verification of the correct calculation. HTH
