go to post David Underhill · Oct 22 Don't forget $query can provide faster iteration through globals, where appropriate.
go to post David Underhill · Sep 26 Just as an example, an alternative with $piece.An issue would be if both startStr and stopStr are the same value which $find does solve. set values="" for n=2:1:$length(text,startStr) { set check=$piece(text,startStr,n) if check[stopStr set values=values_" "_$piece(check,stopStr) return $piece(values," ",2,*)
go to post David Underhill · Aug 27 Great overview, I have had plenty of discussions with IT departments who don't understand that Linux, and Windows, will use available resources, especially for IO, and it is only an issue if it is persistent or unusual, and obviously if there are performance/stability issues.Being able to provide metrics over time and proving it is "normal" usually helps.
go to post David Underhill · Aug 21 This looks so much easier than when I had to do it and is very welcome. At the time I moved it to a personal email so I didn't have to do it again changing companies. This means it should actually be possible to keep it linked to wherever you are working.
go to post David Underhill · Aug 18 I appreciate the comments, some things to think about. If you have planned tables and data properly uniqueness should not be an issue and it looks like the performance consideration is unlikely to be a problem in most cases.Being able to check the raw data easily with a standard global naming is, for me at least, a benefit of not using the hashed names. However, knowing these reasons is very helpful in planning and identifying those edge cases. Is there anything else I have missed that would make this more of an issue?
go to post David Underhill · Aug 15 Without someone providing an accepted linter you won't get everyone to agree on case etc... My own preferences do not all match the above but if we had a defined ruleset that was easily managed and enforceable in the IDE then fine with me. However, I think we should all be able to agree that moving away from shortened commands and names benefits code maintenance and readability plus aligns better with other languages, especially if we use classes, braces, and other "modern" objectscript styles. Yes I know that I am showing my age, but note I avoided mentioning the "M" word 😂
go to post David Underhill · Aug 15 Nice documentation. Some niceties to add that I encountered, all available in the documentation link Iryna provided. - The generated global names are often not very intuitive, you can set these yourself in the CREATE TABLE using %CLASSPARAMETER USEEXTENTSET = 0, %CLASSPARAMETER DEFAULTGLOBAL = '^Packagename.Tablename'; - For concurrency checks similar to PostgreSQL you can add a version property. CREATE TABLE ... ( ... xmin INT, ... ) %CLASSPARAMETER VERSIONPROPERTY = 'xmin'
go to post David Underhill · Apr 29 If you don't use Inter Job Communication devices then set IJCBUFF and IJCNUM to zero. You can also zero NLSTAB if you don't modify collations. I would also turn off NETJOB if not running ECP.
go to post David Underhill · Mar 7 DC Search by a single or range of versions applicable: Search by version | InterSystems Idea
go to post David Underhill · Jun 17, 2024 You can also use iristerm directly in batch mode Running the Terminal Application from the Command Line | Using the Windows Terminal | InterSystems IRIS Data Platform 2024.2 or use IRISDB, an example is below Backup Freeze/Thaw batch script pitfalls for VMWare (and solutions) | (intersystems.com)
go to post David Underhill · Jun 10, 2024 Classes such as Config allow changing these values Config.config - InterSystems IRIS Data Platform 2020.1 - including private class members You could write methods to update these based on passed values and then call them externally from powershell using iris session or iris terminal The iris command | InterSystems IRIS Data Platform 2024.1
go to post David Underhill · Feb 5, 2024 Very useful. I tend to avoid post conditionals nowadays as I long ago realised, as with your other examples, readability was far more important. Only one I do not personally do is the Command Arguments example, I'm old and set in my ways and like using the comma 😁 Another possible mention might be "goto". Oh, and your note on functions not being case-sensitive is only for system (intrinsic) functions. I think the message overall is we no longer have the same memory and screen limitations and so spaced out, readable, and maintainable code is far more important than the old compacted method of writing mumps/objectscript.
go to post David Underhill · Feb 5, 2024 Hi, best thing would be to not use the built-in web server (PWS) and set-up your own Web Gateway in IIS or Apache. These are links to some of the relevant documentation Web Servers for Microsoft Windows | CSP Gateway Configuration Guide | Caché & Ensemble 2018.1.4 – 2018.1.8 (intersystems.com) Web Gateway | InterSystems IRIS Data Platform 2023.3
go to post David Underhill · Nov 30, 2023 Pipes are also a good way to interact with an OS command or external program Pipes | InterSystems IRIS Data Platform 2023.3
go to post David Underhill · Mar 31, 2023 %SYSTEM.OBJ has various compile methods, you can compile individual classes, whole packages, whole namespaces, and so on. https://docs.intersystems.com/iris20201/csp/documatic/%25CSP.Documatic.c... You can also use them via $SYSTEM.OBJ... instead of ##class(%SYSTEM.OBJ)...
go to post David Underhill · Aug 30, 2022 Thanks for the reply. If a user needs to be able to monitor and operate a Production would they not still need access to that data base? Also, that table is granted via %ENSROLE_OPERATOR which such a user will need?
go to post David Underhill · May 6, 2022 Thanks for the explanation, I assumed it worked something like that. Do you agree with that approach though or would you prefer something more like Robert's description? In my mind you don't create a database based on a specific file so the DAT should be swappable and retain the database settings, other database settings work that way.
go to post David Underhill · May 5, 2022 It's good to hear this is going to be added. In the meantime we found using explicit ftps got around it but that may depend on how the ftps server is configured. For explicit ftps I got a very helpful answer in a previous post Explicit FTPS in Cache | InterSystems Developer Community | Data Import and
go to post David Underhill · May 5, 2022 For curl, these help with how to do a POST HTTP POST - Everything curl cURL - POST request examples - Mkyong.com The command line response contains everything and if it is json the below can help JSON - Everything curl As Marc says though, what do you need to be able to do?
