class Ens.Queue visible to ODBC?

Question

Question

Brian Dunlap · Sep 17, 2018

I would like to make the EnsQueue class visible to the Intersystems ODBC client. It appears it must be included in the SQL-visible classes first.

Discussion (9)0

Log in or sign up to continue

Eduard Lebedyuk · Sep 18, 2018

To get queues list call:

Call EnsPortal.Queues_EnumerateQueues()

Or

SELECT *
FROM EnsPortal.Queues_EnumerateQueues()

1 0

score 0 · Answer 1 · 2018-09-18T02:39:33-04:00

Eduard Lebedyuk · Sep 18, 2018

What do you want to do with that information over ODBC?

0 0

score 0 · Answer 2 · 2018-09-18T07:59:58-04:00

Brian Dunlap · Sep 18, 2018

Display queues with contents in a separate application.

0 0

score 0 · Answer 3 · 2018-09-18T08:18:11-04:00

I can run the query statement from the portal > SQL window, or by selecting the stored procedure.

However the wizards > Data Export function fails with a CSP error, so at the moment I can't figure out how to export the query results.

(Healthshare 17.2.1)

score 0 · Answer 4 · 2018-09-18T10:42:26-04:00

Or, another approach - write the query results to a file.

How do I use the 'USE IO WRITE' command to send the query output to the selected device?

score 0 · Answer 5 · 2018-09-18T08:21:29-04:00

Eduard Lebedyuk · Sep 18, 2018

I think it could be a separate question:

How to export data returned from stored procedure.

0 0

score 0 · Answer 6 · 2018-09-19T12:25:05-04:00

Thanks for the update.

We created a workaround involving creating a file of enumerated queues. Much more elegant to just have the Ens.Queue class visible from an ODBC connection....

score 0 · Answer 7 · 2018-09-19T05:18:31-04:00

This is a bug in Sql import & export from Intersystems. There is a quick fix to it. You can call them and ask for it.

score 0 · Answer 8 · 2018-09-19T12:43:27-04:00

set io="c:\temp\test.pdf"
open io:("nw")
use io write tRequest.HttpResponse.Data.Read()
close io

I am creating a pdf file from a http request. Obviously you can change all these