Mark, you need to close connections from Web Gateway to IRIS, so that Web Gateway reconnects and CSPSystem logins with the new role. You can do this in Web Gateway -> Status page -- close button for the second table. Or just restart the web server.
Note -- Roles field in the Audit details. Check that it has %DB_SRFT role when <PROTECT> happens again.
In System Explorer -> Globals check "Show SQL Table Names". You'll see information on how particular global is used.
Hi Joel.
See decK utility https://docs.konghq.com/deck/latest/
%GetParameter:
SET myinst=##class(Sample.Person).%New()
WRITE myinst.%GetParameter("EXTENTQUERYSPEC")
I think the following should do this
write *-3
Please create a separate question. As I understand it is not related to the original one
Please see here https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=GCRN_upgrade20221#GCRN_upgrade20221_tasks
var from your sample is not an object in ObjectScript. It is an object reference.
So in first case you pass object reference by value. In second case you pass object reference by reference. That is reference to object reference.
I don't think you should expect noticeably better performance
Look in "Developer Preview". It's not released yet
If you can select from this stored procedure then you can try to use this select in INSERT into.
Does the following work?
SELECT * Custom_MENS_Other.samplesp('2021-11-02','2021-11-04','H001')
See Table-Valued functions section: https://docs.intersystems.com/ens201815/csp/docbook/Doc.View.cls?KEY=RSQL_from#RSQL_from_tvf
And INSERT with SELECT: https://docs.intersystems.com/ens201815/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_insert#RSQL_insert_select
Hi Thanongsak.
In the <iris>/bin folder you should have different odbcgateway*.so files.
IRIS uses odbcgateway.so when it connects to 3rd party database via ODBC.
However in UNIX world, different ODBC drivers are compiled differently and they can use different driver managers -- iODBC or unixODBC.
Thus IRIS comes with several odbcgateway libraries that are suitable for different drivers.
On my IRIS 2021.1 for macOS I have:
odbcgateway.so -- default one, for iODBC driver 8-bit
odbcgatewayiw.so -- for iODBC driver manager with Unicode support
odbcgatewayur64.so -- supports 8-bit ODBC for 64-bit unixODBC
IRIS documentation covers this here (though filenames are not correct, should be odbcgateway instead of cgate)
https://docs.intersystems.com/iris20221/csp/docbook/DocBook.UI.Page.cls…
So the question is -- what driver manager is libmaodbc.so linked against.
In any case -- Rename odbcgateway.so to odbcgatewayi.so. And then try replacing odbcgateway.so with odbcgatewayiw.so and odbcgatewayur64.so and see with which connection works.
Hi Max.
Try passing %CONTEXT value:
[Measures].[%Count]/%MDX("Select From [Cards]","%CONTEXT","filters")
For more details on possible %CONTEXT values see
https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=D2RMDX_percentKpi
Of course, there are more elegant ways to check the globals and data than expecting an error.
Mario, you left me curious. What are the ways?
Oh, cool! It works with `<TAB>`
I don't understand how you get the first sample working. I'm getting expected <SYNTAX> error
USER>a SET x = 1
A SET x = 1
^
<SYNTAX>
The advice is -- enable OS authentication for the %Service_Terminal. And add the OS user that runs the script to the IRIS.
I'm not aware of secure way of passing credentials for IRIS password users.
https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=GAUTHN_osbased
Try something like
iris session LIVETC01 -U "%SYS" "Monitor^MIRROR"
Hi Lesley.
Please file feedback for the documentation team -- Feedback button on the right of the page. Indeed, it seems like this part of documentation is out of date.
Though if you search on Github, you'll find copies of this class.
For example:
https://github.com/SylvainGuilbaud/iris-code/blob/main/src/cls/XSLT2/Examples.cls
Welcome Aasir!
This question is rather for Crystal Report 2020. Ensemble 2014 provides standard ODBC interface. If Crystal Report 2020 can communicate using this interfacen, then Crystal Report is compatible with Ensemble 2014.
There is no built-in package that does this. You need to use some external library
Hi Eddie.
Does it use it's own internal SQL database or are we able to connect to our own database and which databases are certified to run against the platform?
Both.
Supported 3rd party databases are listed here:
Generally, please see "First looks" guides in our doc, particularly for JDBC and ODBC:
https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=AFINDEX
I think you need to declare RunDownload as a ClassMethod, not ClientMethod, that is for JavaScript methods
Try writing to support@intersystems.com
Your account manager. If you don't know who this is -- contact the InterSystems office that issued you a license. Or contact WRC.
"Why our license does not support ECP, if it's for Multi-Server?"
That's the different question from the one you asked in the post. I suggest you contact your Account Manager in InterSystems.
You can use SQL Gateway to select / modify tables in external databases
Try using SQL Gateway:
Hi Nicky.
See ##class(%Library.EnsembleMgr).IsEnsembleNamespace
I'm not aware of such patch or a hotfix.