go to post Ben Spead · Apr 4, 2023 here it s in practice for those interested: USER>d $system.SQL.Shell() SQL Command Line Shell ---------------------------------------------------- The command prefix is currently set to: <<nothing>>. Enter <command>, 'q' to quit, '?' for help. [SQL]USER>>select $zversion 1. select $zversion Expression_1 IRIS for Windows (x86-64) 2022.1.2 (Build 574U) Fri Jan 13 2023 15:08:27 EST 1 Rows(s) Affected statement prepare time(s)/globals/cmds/disk: 0.1884s/34,356/143,526/0ms execute time(s)/globals/cmds/disk: 0.0007s/0/394/0ms cached query class: %sqlcq.USER.cls1
go to post Ben Spead · Apr 4, 2023 nice! Thanks ... I didn't know you could do things like Select $zversion :)
go to post Ben Spead · Apr 3, 2023 A great primer on a classic design pattern used in ObjectScript. Thanks Robert!
go to post Ben Spead · Apr 3, 2023 Congrats to the winners and thank you to everyone who took time to contribute :)
go to post Ben Spead · Mar 24, 2023 I may be mistaken, but I believe that "Apply" will persist the change and keep you on that screen, while "Update" will persist the change and close the screen. Does it seem to work that way? (I don't have a TC instance here to test with a.t.m.)
go to post Ben Spead · Mar 24, 2023 Calling @Timothy Leavitt to weigh in on this when we gets the chance. @Scott Roth - is your source already on disk or are you looking to dump it all out of the Namespace and to disk?
go to post Ben Spead · Mar 23, 2023 Really great article! I am not sure how I missed it when it was first published. I will be sending this to my whole dev team :)
go to post Ben Spead · Mar 22, 2023 @Pavan Shakti - thank you for sharing your access approach for those that are not supported customers.
go to post Ben Spead · Mar 22, 2023 Link is here: https://wrc.intersystems.com/wrc/coDistGen.csp (can only be accessed by Supported Customers). Put "ODBC" in the Name filter and "Cache" in the Product filter and you'll see 14 options for download based on your platform.
go to post Ben Spead · Mar 20, 2023 @Evgeny Shvarov / @Developer Community Admin - THANK YOU for the feature that allows you to display your professional certifications in your profile, as well as the check-mark on your profile pic .... love it! Has any thought been given to the second idea of being able to see a list of people who publicly listed a specific certification? That would make the experts more discoverable.
go to post Ben Spead · Mar 17, 2023 Thanks! I confirmed that this will work on older Linux machines, but it won't work for our example as RHEL 9 removes Telnet from the distribution since it is unencrypted (at least that is what I was told). But for people UNIX machines which have Telnet installed it looks like this is a great option!
go to post Ben Spead · Mar 17, 2023 Thanks for the ideas @Robert Cemper , but I was looking for something dead-simple at the UNIX level, and nc does the trick :)
go to post Ben Spead · Mar 17, 2023 Thanks @Guillaume Rongier ! That works great. FYI ... we can see the request attempt on the IRIS side with a Description = "%Service_SuperServer login failure", noting the IP Address of your Linux web server, and Event Data which mentions "Error message: ERROR #949: Unable to get full header of message within timeout"
go to post Ben Spead · Mar 17, 2023 ^SSADMIN is a TrakCare utility so you will need to look in the TrakCare documentation on that (and/or add the TrakCare tag to this question - not sure if that will send out new notifications to people who follow that Tag). The Production page from the SMP is for the InterSystems IRIS Interoperability Productions for which I linked docs above. I am guessing the "Interfacing" is a specific TrakCare feature which uses Productions and other pieces of InterSystems IRIS Interoperability beneath the covers.
go to post Ben Spead · Mar 15, 2023 @Olga Zavrazhnova - is there still a 150 point bonus for accepted answers on the D.C.?