Holy cow @Chad Severtson, that's really cool! Do you know when that was added / where I can find more information? I don't see it in the docs on SQL Shell (https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=GS…).
Also, what is the ":" shorthand for and where else can it be used?
thank you for sharing the answer :)
Thank you for circling back on this and sharing your solution Tim :)
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
nice! Thanks ... I didn't know you could do things like Select $zversion :)
A great primer on a classic design pattern used in ObjectScript. Thanks Robert!
Congrats to the winners and thank you to everyone who took time to contribute :)
glad to help!
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.)
okay, thanks Scott for the that update
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?
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 :)
great to know - thank you :)
@Pavan Shakti - thank you for sharing your access approach for those that are not supported customers.
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.
@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.
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!
thank for the additional idea!
Thanks for the ideas @Robert Cemper , but I was looking for something dead-simple at the UNIX level, and nc does the trick :)
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"
^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.
great, thank you!
@Olga Zavrazhnova - is there still a 150 point bonus for accepted answers on the D.C.?
@Michael Lei - I have updated the link to point to the 2016.2 Supported Platform list:
https://cedocs.intersystems.com/ens20162/csp/docbook/DocBook.UI.Page.cl…
Very nice initial How-To! Thank you especially for the animated GIFs!
@Phillip Wu - you will need to be a little more specific. There are a number of 'Gateways' in InterSystems products (e.g. Web Gateway, SQL Gateway, etc), but I don't know of any of them that are specifically an interoperability component. You could have an interface which uses a gateway to get data, but again the specifics are really important here :) Also, if you are using a production that someone else created, they could call something a "Gateway" which is their term and not necessarily indicative of something specific to an InterSystems product.
Great write-up (thank you for the animated GIFs!) This makes it so simple for people to get started - appreciate the write-up
@Phillip Wu - I suggest you start with the introductory material in the documentation:
https://docs.intersystems.com/irisforhealth20223/csp/docbook/Doc.View.c…
That should help you to get your feed under you with these basic concepts.
Hope that helps!
Calling @Chris Munt or @Chris Munt (not sure which is the right handle)
Well done all!!
An especially big CONGRADS to @Heloisa Ramalho who is a member of the AppServices team at InterSystems - I'm proud to be able to work with her :)