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
go to post Robert Cemper · Dec 23, 2022 It's the classic impedance mismatch: AOC goes for time and numbers. For the numbers, you may calculate them, gamble, get inspired, or ... this contest goes straight for ObjectScript and I will verify the calculation
go to post Robert Cemper · Dec 20, 2022 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 utilitiesthat 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.
go to post Robert Cemper · Dec 20, 2022 according to my info none of the top 9 are employed by ISC.@Anastasia Dyubaylo can you pls. check this?
