go to post Vivek Ranjan · Feb 9, 2018 What's hstmt? You can call like this. SET sc= gc.%Prepare(pQuery)
go to post Vivek Ranjan · Feb 1, 2018 Would be good if we get this for Object Script. May be better to understand how Atelier editor does format the code.
go to post Vivek Ranjan · Feb 1, 2018 My question is whether .net gateway service can be used when you have to call class library(dll) on Linux hosted ensemble instance.I know it's ridiculous to expect .net framework on Linux(can be done with .net core, mono), but how you can overcome a situation where complex logic is built in c# class and a dll is given to you for quick implementation.
go to post Vivek Ranjan · Feb 1, 2018 Language integrated query is a concept where you tend to query data like SQL. My question about the same. I've given a simple example of c# LINQ at the top.
go to post Vivek Ranjan · Jan 8, 2018 Yes seems like this.Able to browse: http://localhost:57772/api/atelier/but nothttp://xyxz.x.edu/instance/api/atelier/ It's enabled on the server.
go to post Vivek Ranjan · Jan 8, 2018 You can use Using the Caché Object Binding for .NET. Call the proxy class through console app/any class library. http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GBMP_proxy
go to post Vivek Ranjan · Jan 8, 2018 IM Renderer Page <table class="msgText"> <tr> <td class="errorAlertIco"><img src="res://instant-message.dll/#10/#2415" /></td> <td class="boxedMessageText">It appears that you do not have JavaScript enabled, please contact your adminitrator.</td> </tr> </table> Cache for Windows (x86-64) 2017.1.1 (Build 111_0_17521U) Wed Jul 26 2017 13:08:05 EDT
go to post Vivek Ranjan · Jan 8, 2018 Port 57772 is for local host. The remote hosted instance runs on port 80(xyz.x.edu)
go to post Vivek Ranjan · Jan 2, 2018 Works like charm in local windows machine. I was trying to configure the same where the ensemble instance is hosted on Linux machine and there is no path for .net gateway service. There isn't any folder with dotnet where DotNetGatewaySS.exe can be found. InterSystems\Ensemble20162\dev\dotnet\bin\v4.0.30319
go to post Vivek Ranjan · Dec 10, 2017 I tried your quey and it ran successfully.SELECT * FROM Config.IO WHERE ID IN ('1||1||9852553062' , '1||1||9852553061' ) order by 1 descThe error you got seems very generic. Kindly check the table again.The SQLCODE -400 error “Fatal error occurred” is a general error. It is generated when a more specific SQLCODE error code is not available.
go to post Vivek Ranjan · Nov 24, 2017 Thanks @Robert Camper. If the DATEPART() always takes logical mode value irrespective of display mode selected in SQL query viewer, I was wondering there is implicit conversion of Timecreated Column(column1 in abobe example) to the mode selected in SQL query window.