How to run a sql on a different server from cache itself

Question

Question

Tirthankar Bachhar · Mar 6, 2019

what class or API I shall be using to execute a piece of sql to another server from one server? From within cache itself not java or python or any other languages.

Anything like $System.SQL.%Connect(...) ?

Discussion (4)2

Log in or sign up to continue

Vitaliy Serdtsev · Mar 7, 2019

See %RemoteResultSet.

2 0

score 0 · Answer 1 · 2019-03-07T15:30:59-05:00

Thanks so much, made my day. I have been searching for this one exactly!!! This forum is so great, I’m glad to be part of it!

score 0 · Answer 2 · 2022-06-09T08:48:09-04:00

Tirthankar Bachhar · Jun 9, 2022

%RemoteResultSet has been removed in later version. Not available anymore.

0 0

score 1 · Answer 3 · 2022-06-09T09:34:32-04:00

Alexander Koblov · Jun 9, 2022

Try using SQL Gateway:

https://docs.intersystems.com/iris20221/csp/docbook/DocBook.UI.Page.cls?...

1 0