Accessing Caché from windows Command line terminal

Question

Question

Raouf Besbes · Feb 21, 2018

Hi,

I would like to know if it is possible to use windows command line , instead of Intersystems Terminal , to connect to Caché and do objectscript commands or SQL requests as a client.

Thank you for your help

Discussion (6)0

Log in or sign up to continue

Dmitry Maslennikov · Feb 21, 2018

you can use cterm.exe for this task, so, you can run some script, or routine in Cache

or just run cache.exe directly.

Microsoft Windows [Version 10.0.16299.248]
(c) 2017 Microsoft Corporation. All rights reserved.

C:\Users\Admin>c:\intersystems\ensemble\bin\cache.exe -sc:\intersystems\ensemble\mgr\

Node: DESKTOP-4IDCEJ0, Instance: ENSEMBLE

USER>

1 0

score 0 · Answer 1 · 2018-02-21T10:38:17-05:00

Raouf Besbes · Feb 21, 2018

Great! Thank you very much Dmitry

0 0

score 0 · Answer 2 · 2020-03-04T04:34:13-05:00

Konstantin Terekhov · Mar 4, 2020

File cache.exe does not exist.

How to do the same in the case of IRIS?

0 0

score 0 · Answer 3 · 2020-03-04T04:46:30-05:00

Dmitry Maslennikov · Mar 4, 2020

you have two options, instead of cache.exe use irisdb.exe

or use command iris terminal <instancename>

0 0

score 0 · Answer 4 · 2020-03-04T04:55:31-05:00

Thank you, Dmitry. But response from irisdb not readable (I am from Russia).
chcp 1251 not help.
How force IRIS talk on english ?

╨Ч╨░╨│╤А╤Г╨╖╨║╨░ ╨┤╨╕╤А╨╡╨║╤В╨╛╤А╨╕╨╕ ╨╜╨░╤З╨░╨╗╨░╤Б╤М ╨▓ 03/04/2020 12:48:53

╨Ю╨и╨Ш╨С╨Ъ╨Ф╨╕╤А╨╡╨║╤В╨╛╤А╨╕╤П 'D:\?раб?тка\05-Cache and Git\\source\cls' ╨╜╨╡ ╤Б╤Г╤Й╨╡╤Б╤В╨▓╤Г╨╡╤В.
╨Ю╨▒╨╜╨░╤А╤Г╨╢╨╡╨╜╨╛ 1 ╨╛╤И╨╕╨▒╨╛╨║ ╨▓╨╛ ╨▓╤А╨╡╨╝╤П ╨╖╨░╨│╤А╤Г╨╖╨║╨╕.
IMPORT STATUS: ╨Ю╨и╨Ш╨С╨Ъ╨Ф╨╕╤А╨╡╨║╤В╨╛╤А╨╕╤П 'D:\?раб?тка\05-Cache and Git\\source\cls' ╨╜╨╡ ╤Б╤Г╤Й╨╡╤Б╤В╨▓╤Г╨╡╤В

score 0 · Answer 5 · 2020-03-04T05:38:27-05:00

Open Management portal (guess it is on http://localhost:52773/csp/sys/UtilHome.csp) and switch the local in About menu from English to Russian