class Ens.Queue visible to ODBC?

Caché, Ensemble, ODBC

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.

  • 0
  • 0
  • 136
  • 8
  • 1

Answers

To get queues list call:

Call EnsPortal.Queues_EnumerateQueues()

Or

SELECT *
FROM EnsPortal.Queues_EnumerateQueues()

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)

I think it could be a separate question:

How to export data returned from stored procedure.

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.

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....

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?

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 

Comments

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

Display queues with contents in a separate application.