go to post Robert Cemper · Mar 22, 2024 set x="1,4,6,8,9,12" while x>0 {write +x,! set x=$piece(x,",",2,*) } x only !
go to post Robert Cemper · Mar 21, 2024 set X="1,4,6,8,9,12" for i=1:1:$L(X,",") set Y=$p(X,",",i) write Y,!
go to post Robert Cemper · Mar 21, 2024 I just realized that $vector() is a left+right function similar to $li() set $vector(target,...) = .... to set set vec = $vector(...) to get
go to post Robert Cemper · Mar 21, 2024 Thanks. I just looked for TO_VECTOR but failed at that timehttps://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...covers my needs.
go to post Robert Cemper · Mar 21, 2024 Thanks.I was looking for this but couldn't detect.https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_fvector It is not on https://docs.intersystems.com/iris20241/csp/docbookbut on https://docs.intersystems.com/irislatest/csp/docbook which is not covered by Doc Search
go to post Robert Cemper · Mar 21, 2024 experimenting with class %Library.Vector I found an unattractive way: ;; compose JSON array >> v USER>zw v v=[($double(.5)),($double(1.5)),($double(2.2000000000000001776))] ; <DYNAMIC ARRAY> USER>set vec=##class(%Vector).OdbcToLogical(v) USER>zw vec vec={"type":"double", "count":3, "length":3, "vector":[$double(.5),$double(1.5),$double(2.2000000000000001776)]} ; <VECTOR> Applying OdbcToLogical was really shocking
go to post Robert Cemper · Mar 21, 2024 Indeed:I was unable to locate an official docu on new SQL function TO_VECTOR()Similarly, I found no documentation on how to set a VECTOR Datetype on pure object levele.g. obj.vectorproperty = ?????? or obj.vectorproperty.set(?????)I tried a bit with DisplayToLogical but gave up in the end
go to post Robert Cemper · Mar 21, 2024 Routine names starting with %Z or %z go to namespace %SYS automatically:Though by mapping it to namespace %ALL any routine can be available in any namespace
go to post Robert Cemper · Mar 20, 2024 Hi al!,Just returning from some private troubleshooting I'm deeply moved and thankful for this feedback.It's once more a motivation to continue my activities.Sometimes I'm insisting on small pieces that may bypass general attention.Though servicing customers - and I understand you all as my customers -requires to take care also of the small and often annoying pieces. Special big THANKS to the brilliant team behind the DC+OEX+GM facility.YOU ARE GREAT. 💐🌷🌺🌸💮🌼🌻
go to post Robert Cemper · Mar 16, 2024 CLOSING / SOLVED I bought a new box with an N100 processor I got a Win11 Pro included for free Installed a new Docker Desktop version (48.0) And all the necessary infrastructure around 5 hrs later the fresh IRIS 2014.1 runs inside and outside Docker ¡ with some 100$ invested at the right time you can solve a lot of problems !
go to post Robert Cemper · Mar 13, 2024 Thank you for publishing my attempts and the clear message: There is not just 1 solution. !
go to post Robert Cemper · Mar 9, 2024 I guess I'm trapped https://community.intersystems.com/post/intersystems-iris-minimum-supported-cpu-models#comment-242346
go to post Robert Cemper · Mar 9, 2024 Sorry, the same result. several pages. I'll ask WRCI fear my processor is just to old. WRC LOG
go to post Robert Cemper · Mar 7, 2024 Special thanks for Step 4 - Dockerthis allows you to train the technical presentation over and over in the same wayNothing is more disturbing than a presenter who seems to see the code first time 😎
go to post Robert Cemper · Mar 5, 2024 you are in Caché so this might help:http://localhost:57772/csp/docbook/DocBook.UI.Page.cls?KEY=GIOD_rmsseqfilesUSE file:positionthe equivalent in %Stream,Object is MoveTo • method MoveTo(position As %Integer) as %Boolean Move to this position in the stream. If this suceeds then return true, else return false. Note this implementation is not efficient because it searches from the start of the stream, it can be improved upon in specific subclasses. Note that moving to position 1 will be at the start of the stream, position 2 will be at the second character of the stream, etc. And then you do your Read or Find..
go to post Robert Cemper · Mar 5, 2024 Hi @Luis Angel Pérez RamosI got in fact the same values with my iris community edition. Test Columnar vs. Row Storage ============================= 1 - Initialize Tables 2 - Generate Data 3 - Compare SELECT 4 - Loop SELECT 5 - Auto Loop Select Function or * to exit : 5 Loops to run :25 Set steps by loop Records to add (1...10000)[1]:10000 records = 15000 row = .033238 col = .044981 records = 25000 row = .007728 col = .000254 records = 35000 row = .011427 col = .000335 records = 45000 row = .014625 col = .000406 records = 55000 row = .018682 col = .000500 records = 65000 row = .023468 col = .000562 records = 75000 row = .026235 col = .000659 records = 85000 row = .029151 col = .000738 records = 95000 row = .032212 col = .000794 records = 105000 row = .035926 col = .000856 records = 115000 row = .039431 col = .000934 records = 125000 row = .043036 col = .001008 records = 135000 row = .049134 col = .001074 records = 145000 row = .050405 col = .001404 records = 155000 row = .054313 col = .001669 records = 165000 row = .058039 col = .001380 records = 175000 row = .060756 col = .001384 records = 185000 row = .064746 col = .001451 records = 195000 row = .068403 col = .001665 records = 205000 row = .070737 col = .001642 records = 215000 row = .073610 col = .001690 records = 225000 row = .078551 col = .001797 records = 235000 row = .084139 col = .001997 records = 245000 row = .087316 col = .001908 records = 255000 row = .087862 col = .002546 records = 265000 row = .090478 col = .002152
go to post Robert Cemper · Mar 5, 2024 You might appreciate this approach https://community.intersystems.com/post/columnar-vs-row-storage-iris-nativeand BTW. thanks for the inspiration.
