go to post Ben Spead · Apr 12, 2023 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
go to post Ben Spead · Apr 12, 2023 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
go to post Ben Spead · Apr 11, 2023 seriously! it's amazing how much knowledge there is to be gleaned within this community :)
go to post Ben Spead · Apr 11, 2023 Bravo gentlemen!! thank you for your continued investment in our community :)
go to post Ben Spead · Apr 10, 2023 Another very cool aspect of the feature :) So it looks like this is just a built-in alias which ships with InterSystems IRIS.
go to post Ben Spead · Apr 7, 2023 @Dmitry Maslennikov - thank you! Docs reference? Do you know what the ":" syntax is?
go to post Ben Spead · Apr 7, 2023 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=GSQ...). Also, what is the ":" shorthand for and where else can it be used?
go to post Ben Spead · Apr 4, 2023 Thank you for circling back on this and sharing your solution Tim :)
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 :)
