Thanks Chad - I think that this would be the lowest impact overhead approach if I don't copy the definitions directly via a clone or the globals
- Log in to post comments
Thanks Chad - I think that this would be the lowest impact overhead approach if I don't copy the definitions directly via a clone or the globals
Thanks Vik ... that sounds like a good approach to play with!
Thanks Matt, I am trying to avoid using the OS as the middle-man in this case as we have 300+ namespaces to do this on and so should be scripted. I can create a %Method that would do this but was hoping for a quick command that could just do the transfer
seriously! it's amazing how much knowledge there is to be gleaned within this community :)
Bravo gentlemen!! thank you for your continued investment in our community :)
Another very cool aspect of the feature :) So it looks like this is just a built-in alias which ships with InterSystems IRIS.
nice intro - thank you!
@Dmitry Maslennikov - thank you! Docs reference? Do you know what the ":" syntax is?
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!