Did you know that IRIS Terminal could do this?!?! History and Aliases! |

Joel Solon · Dec 30, 2021

:alias sql do $system.SQL.Shell()

:alias err do $system.Status.DisplayError($1)

1 0

Robert Cemper · Dec 30, 2021

WOW !! GREAT !

0 0

Jose-Tomas Salvador · Dec 31, 2021

Thanks Joel! I saw it in early previews and I didn't realize there were already these shorcuts... perhaps they weren't there yet.

One question... how could we save the alias we have defined so to "import" and use them in other instances?

0 0

Dan Pasco · Jan 4, 2022

I like :sql as a way to launch the shell - so that means this alias should be renamed to something else!!

USER>:sql "select top 2 * from person"
do $system.SQL.Execute("select top 2 * from person").%Display()
id    name    ssn    dob    home_street    home_city    home_state    home_zip
1    Willeke,Thelma K.    934-46-2099    18948    308 Madison Blvd    Bensonhurst    HI    71501
2    Nathanson,Will P.    771-91-1008    37359    9664 Second Place    Jackson    VA    15837

2 Rows(s) Affected

0 0

Joel Solon · Jan 4, 2022

I have one older IRIS instance (unreleased v2021.1 with some Python extras) that has the following aliases built in. The :sql alias doesn't run Execute() like it seems to do on yours.

:py          Do $system.Python.Shell()
:mdx         Do $system.DeepSee.Shell()
:sql         Do $system.SQL.Shell()
:tsql        Do $system.SQL.TSQLShell()

0 0

Dan Pasco · Jan 4, 2022

That's because I defined that alias myself - on Linux it is the .iris_init file in my home directory. I don't know where that is on Windows...

0 0

Joel Solon · Jan 4, 2022

Ah, I misinterpreted "this alias" in your post! So you meant (I added italicized text): "I like to define :sql as a way to launch the shell and execute a statement - so that means this built-in :sql alias should be renamed by InterSystems to something else!! or be removed."

At least aliases defined in .iris_init override any built-in aliases.

0 0

Dan Pasco · Jan 4, 2022

Not quite - I just defined that alias this morning to test something out. I think that a pre-defined (shipped with Iris) sql alias should launch the shell - I didn't know anything about pre-installed/shipped with Iris aliases.

0 0

Evgeny Shvarov · Dec 30, 2021

Cool stuff! Thanks, Joel!

0 0

Eduard Lebedyuk · Dec 30, 2021

Cool.

I use custom ObjectScript commands via ^%ZLANG Routines.

Advantages:

Crossplatform
Easy to transfer between servers
Available since times immemorial

Post your favorite aliases below.

SQL shorthand is definitely useful.

2 0

Jeffrey Drumm · Jan 1, 2022

Hi Joel, is there any way to persist aliases from session to session?

1 0

Evgeny Shvarov · Jan 2, 2022

Perhaps a ZPM package that sets all up can help?

0 0

Jeffrey Drumm · Jan 2, 2022

Thanks, Evgeny. Do you have a sample/example of how that might be done?

0 0

Evgeny Shvarov · Jan 3, 2022

Honestly have no idea ) It's was just thought between NY salads eating) But I bet @Robert C. Cemper or @Dmitry Maslennikov could suggest something. I bet Terminal saves aliases in some global that could be investigated. It's a hack of course thus not recommended officially until we document the global.

If you use Docker for development with IRIS this could be easier. E.g. we could run the terminal program(what is it BTW?) during the iris.script phase and setup aliases of taste.

0 0

Robert Cemper · Jan 3, 2022

Hi! though this looks like a nice feature it is not so useful if not portable and
even available in ZPM.
I use since ~ever~ my 3..5 char abbreviated extensions in %ZLANG...*
to add such abbreviations I have even created my helper to add it o the fly
Helper for ObjectScript Language Extensions with OEX + Video

And sorry where is the difference between :sql to ZSQL or zsql (insensible to any mix of case) ?
In addition in %ZLANG* your shortcut can also be a multiline function.

0 0

Dmitry Maslennikov · Jan 3, 2022

It looks like, it already persists somehow. I'm using docker, after halt command, I've entered the same container back with session, looked at :h and is history there, as well as aliases.

0 0

Dmitry Maslennikov · Jan 3, 2022

Nope, aliases not persisted, but :sql, :s works as SQL Shell without aliasing it

0 0

Jeffrey Drumm · Jan 3, 2022

Hmm. :sql or :s does not seem to work for me without actually creating an alias. I'm currently testing this with HealthShare, $ZV = IRIS for Windows (x86-64) 2021.1 (Build 215_0_21260U) Tue Nov 9 2021 19:30:33 EST. Maybe a 2021.2 feature?

0 0

Dmitry Maslennikov · Jan 3, 2022

docker exec -it iris iris session iris

Node: fa3f20fc42dc, Instance: IRIS

USER>w $zv
IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2021.2 (Build 617U) Thu Dec 9 2021 15:00:18 UTC
USER>:c

USER>:h
 1: :h

USER>:a

USER>:sql
SQL Command Line Shell
----------------------------------------------------

The command prefix is currently set to: <<nothing>>.
Enter <command>, 'q' to quit, '?' for help.
[SQL]USER>>  << entering multiline statement mode, 'GO' to execute >>
    1>>q
[SQL]USER>>q

USER>:t
SQL Command Line Shell
----------------------------------------------------

The command prefix is currently set to: <<nothing>>.
Enter <command>, 'q' to quit, '?' for help.

dialect = MSSQL
[SQL]USER>>

even :t for TSQL dialect

0 0

Jeffrey Drumm · Jan 3, 2022

Node: Krusty, Instance: HEALTHSHARE
 
Username: jeff
Password: ****
USER>:c
 
USER>:h
 1: :h
 
USER>:a
 
USER>:sql
>> Invalid history command
 
USER>:t
>> Invalid history command
 
USER>w $ZV
IRIS for Windows (x86-64) 2021.1 (Build 215_0_21260U) Tue Nov 9 2021 19:30:33 EST

Maybe you're seeing a 2021.2 behavior.

Or it's just this docker thing the cool kids use ...

0 0

Stefano Cairoli · Jan 3, 2022

To get a list of the built-in aliases, try ":?", this is from 2021.1 for example:

USER>:?
:<number> Recall command # <number>
:? Display help
:alias Create/display aliases
:clear Clear history buffer
:history Display command history
:unalias Remove aliases

Note how indeed we don't have :sql in the 2021.1 release, it came later..

0 0

Joel Solon · Jan 3, 2022

Here's some info that was inadvertently removed from the docs, but will be returning soon:

On Unix systems, if a file named ~/.iris_init exists, it is read when a terminal session is initiated. Only lines starting with :<command> are processed. All other lines are ignored. This file accepts only :alias commands, which enables you to store favorite command abbreviations there.
Example of a ~/.iris_init file:

# Initial aliases
:alias %  zn "%SYS"
:alias load Do $System.OBJ.Load("$1",$S("$2"="":"ck",1:"$2"))
:alias ut Do ##class(%UnitTest.Manager).RunTest("$1")

3 0

Jose-Tomas Salvador · Jan 4, 2022

Now just needs to be a way to "import it"/"preserve"/"make it easier" in Windows systems, to cover the other 70% of people.

1 0

Jeffrey Drumm · Jan 4, 2022

You Windows users have scripting ...

wait for: Username:
send: username<CR>
wait for: Password:
send: password<CR>
send: :alias sql Do $system.SQL.Shell()<CR>
send: :alias % zn "%SYS"<CR>

Save the script to a file with an .scr extension, and start terminal with:

\path\to\iristerm.exe /console=cn_iptcp:hostname[port] \path\to\scriptname.scr

0 0

Jose-Tomas Salvador · Jan 4, 2022

Yep, I know. But I hoped something more "transparent"... if we deal with several instances and change with certain frecuency (as it's my case), having to define direct accesses when we have a link in the "cube" menu, doesn't seem too clean. For Linux/Mac users, the solution is clean. You just define your aliases file, and you just can install your IRIS instances... all of them would make use of them seamlessly... that's the functionality. Right now, for windows users, it's incomplete. A pity because it's a really very good feature to have, our terminal/shell needs these kind of tools, but it has to be much easier to reuse among instances. IMHO.

Perhaps it would be as easy as to change our installer so to include that argument out-of-the-box in the call to Terminal in the cube... and then let the developers build their own script in their own home directory.

0 0

Ben Spead · Jan 3, 2022

Wow - that is so cool!! Thank you for sharing @Joel Solon :)

0 0

Sylvain Guilbaud · Aug 17, 2023

These shortcuts are really handy 😀

Many of them are pre-installed with IRIS.

2023.2

USER>w $zv
IRIS for UNIX (Ubuntu Server LTS for ARM64 Containers) 2023.2 (Build 227U) Mon Jul 31 2023 17:43:25 EDT
USER>:?
 :<number>    Recall command # <number>
 :?           Display help
 :py          Do $system.Python.Shell()
 :mdx         Do $system.DeepSee.Shell()
 :sql         Do $system.SQL.Shell()
 :tsql        Do $system.SQL.TSQLShell()
 :alias       Create/display aliases
 :clear       Clear history buffer
 :history     Display command history
 :unalias     Remove aliases

USER>

2023.1.1

USER>w $zv
IRIS for UNIX (Ubuntu Server 22.04 LTS for ARM64) 2023.1.1 (Build 380U) Fri Jul 7 2023 23:52:03 EDT
USER>:?
 :<number>    Recall command # <number>
 :?           Display help
 :py          Do $system.Python.Shell()
 :mdx         Do $system.DeepSee.Shell()
 :sql         Do $system.SQL.Shell()
 :tsql        Do $system.SQL.TSQLShell()
 :alias       Create/display aliases
 :clear       Clear history buffer
 :history     Display command history
 :unalias     Remove aliases

USER>

0 0