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.
I tried your quey and it ran successfully.
SELECT * FROM Config.IO WHERE ID IN ('1||1||9852553062' , '1||1||9852553061' ) order by 1 desc
The 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.
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
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.
Port 57772 is for local host. The remote hosted instance runs on port 80(xyz.x.edu)
It's 2017.1.1 Build 111
Yes
IM Renderer Page
|
Cache for Windows (x86-64) 2017.1.1 (Build 111_0_17521U) Wed Jul 26 2017 13:08:05 EDT |
api/atelier is not accessible.
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
Yes seems like this.
Able to browse: http://localhost:57772/api/atelier/
but not
http://xyxz.x.edu/instance/api/atelier/
It's enabled on the
server.
Already raised WRC. No resolution so far.
Still investigation on the reference post.
Still investigation on the reference post.
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.
Would be good if we get this for Object Script. May be better to understand how Atelier editor does format the code.
What's hstmt? You can call like this. SET sc= gc.%Prepare(pQuery)
Task Type in UI is nothing but the Class in which you are wrapping your code.
Class Task.Classname Extends %SYS.Task.Definition
{
Set tSC = ##class(Ens.Director).CreateBusinessService("service name",.tService)
If ($IsObject(tService)) {
Set input = ##class(service class??).%New()
Set input.Value = 22
Set tSC = tService.ProcessInput(input,.output)
}
}
Something like when you are inside a class, just right click on 'get related associated project' and get the all the projects which contains that class.
Idea is to add extra menu option on right click.
You can try referring the multiple jar files as list to gateway.
Set AssemblyFileNameWithPath1="jar path 1"
Set AssemblyFileNameWithPath2="jar path 2"
Set gateway=##class(%Net.Remote.Gateway).%New()
Set classpath=##class(%ListOfDataTypes).%New()
Do classpath.Insert(AssemblyFileNameWithPath1)
Do classpath.Insert(AssemblyFileNameWithPath2)
Set status=gateway.%Connect(Host,Port,NameSpace,10,classpath)
To make it more clear, I've a REST service which takes 'SOAP Request' in it's body and forward the request to SOAP endpoint. Now I have to call this service where I need to frame a SOAP envelope. I created the SOAP client and it can call only SOAP service(end point is a class with SOAP webmethod class). But in this case a SOAP envelop needs to be created to pass it to REST's POST.
The trace can be captured through outside app. I need the string to be populated in objectscript.
Who is capturing those event. I am not.
Well my question has to scoped within object script. Trying to find the way. How about creating the request using %XML.Writer.
Expected Output for class 'Myclass'
Class User.Myclass
{
Property Username As %String;
Property Password As %String;
}
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:s="http://www.w3.org/2001/XMLSchema">
<SOAP-ENV:Body>
<Myclass xmlns="http://www.xyz.com/test">
<Username>123</Username>
<Password>123</Password>
</GetSecurityToken>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
Fortunately It's known what to be sent.
I guess the output is written to i/o device. Do we need to change the i/o device to store in variable. May be we can use ^SPOOL global?
Is it so. Before the SP is executed on target DB, the statement must be prepared and a exec statement is run in the below form. I am expecting this to capture.
exec pSPName '1', '2', '3'
Well, I am looking to capture this for analysis purpose. I need not frame those exec statement manually.
I too faced the same problem when my PC host name changed. After deleting cache.ids file it worked.