go to post Alexander Koblov · Oct 24, 2022 In System Explorer -> Globals check "Show SQL Table Names". You'll see information on how particular global is used.
go to post Alexander Koblov · Oct 4, 2022 Hi Joel. See decK utilityhttps://docs.konghq.com/deck/latest/
go to post Alexander Koblov · Oct 3, 2022 %GetParameter: SET myinst=##class(Sample.Person).%New() WRITE myinst.%GetParameter("EXTENTQUERYSPEC")
go to post Alexander Koblov · Sep 28, 2022 I think the following should do this write *-3 https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...
go to post Alexander Koblov · Sep 27, 2022 Please create a separate question. As I understand it is not related to the original one
go to post Alexander Koblov · Sep 27, 2022 Please see herehttps://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...
go to post Alexander Koblov · Sep 16, 2022 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
go to post Alexander Koblov · Sep 6, 2022 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=RSQ... And INSERT with SELECT:https://docs.intersystems.com/ens201815/csp/docbook/DocBook.UI.Page.cls?...
go to post Alexander Koblov · Aug 31, 2022 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-bitodbcgatewayiw.so -- for iODBC driver manager with Unicode supportodbcgatewayur64.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.