All
Accepted answers
Robert Cemper · Nov 16, 2020 go to post

Hello @Anna Golitsyna!
the 3rd example is 1 class that contains 2 basic functionalities:  A Server and a Client.
The system you want to control runs the ClassMethod Server.
- opens an IP port and listens for orders, execute it, and continue looping.
- it is typically started in the background during  system start (from %ZSTART.mac)
This is the "hidden Login"
The (Classmethod) Client connects to the listening port and sends a request and gets answers.
The structure of Requests and Answer is up to you and makes sure you have always control
over what should happen on the remote system. As your  "Listener" is active already there
is no need for any further login. But you are of course free to implement it on top of this basic mechanic.

Robert Cemper · Nov 13, 2020 go to post

The major impact is the default collation for CACHETEMP/IRISTEMP.   This may affect sorting!

There is my related question Multi Language Sort  

@Vitaliy Serdtsev provided an excellent solution as reply to the problem
including a detailed example of how to cover solve the issues I found
with basic features already available in Caché since almost ever(?).

Robert Cemper · Nov 12, 2020 go to post

methodname_"Response" is hardcoded in system class  %SOAP.WebService
I would warn for writing a customized version of it.

Robert Cemper · Nov 12, 2020 go to post

To get rid of xmlns: attribute In your SOAPservice class you may try

Paramter NAMESPACE = "";
Robert Cemper · Nov 11, 2020 go to post

With MS SQL it's even easier as you can directly run ClassMethods/Procedures  written in TSQL

Robert Cemper · Nov 10, 2020 go to post

Besides the functionality and speed that you mentioned already,
there come other factors to my mind. Just a few from the hip:

  • Portability: Moving a Caché/IRIS DB from one system to the other is as easy as a file copy. And this goes across most actual operating platforms on local HW or in the cloud, from Win to *X and back
  • Flexibility: Splitting or extending your DB if you run out of disk space has no impact on the applications. Vertical or horizontally scaling is a standard feature
  • Connectivity: especially with IRIS you have a huge range of adapters and interfaces available that allow access not only by SQL but also by Objects without any need to separate the data accessed from each other.
  • Openness: You need a private SQL Function or SQL Procedure because Standards don't fit?   No problem: Just add your self modeled ClassMethod and you have it done for both SQL and Object access.  

As I mentioned already in a different place: The only limit is your own imagination.  
 

Robert Cemper · Nov 10, 2020 go to post

There is my related question Multi Language Sort  and the new extension may cover some very simple cases.

@Vitaliy Serdtsev provided an excellent solution as reply to the problem
including a detailed example of how to cover solve the issues I found
with basic features already available in Caché since almost ever(?).

Robert Cemper · Nov 9, 2020 go to post

with error trapping

/// Set value to %session.Data 
ClassMethod setValue(params...) As %Status
{
 try {
   set var=$name(%session.Data)
   for i=1:1:params-1 set var=$name(@var@(params(i)))
   set @var=$g(params(params))
   set status=$$$OK
  }
  catch { set status=$system.Status.Error(710)
  }
  quit status 
 }
Robert Cemper · Nov 9, 2020 go to post

it doesn' trap this cases yet

do ..setValue("key1", "key2", , "key4", "val")
do ..setValue("key1", "key2", "", "key4", "val")
Robert Cemper · Nov 9, 2020 go to post

did you mean that ?

/// Set value to %session.Data 
ClassMethod setValue(params...) As %Status
{
quit:params<2 0
set var="%session.Data("
for i=1:1:params-1 set var=var_"params("_i_"),"
set $e(var,*)=")"
set @var=params(params)
quit $$$OK
}
Robert Cemper · Nov 9, 2020 go to post 
/// Set value to %session.Data 
ClassMethod setValue(params...) As %Status
{
 quit:params<2 0
 set var="%session.Data("
 for i=1:1:params-1 set var=var_""""_params(i)_""","
 set $e(var,*)=")"
 set @var=params(params)
 quit $$$OK
}
Robert Cemper · Nov 6, 2020 go to post

The scope and the dimension of possibilities are much wider with IRIS than it was with Caché.
Very generally speaking: There is nothing in Caché that you can't do with IRIS.
The only thing you might miss eventually, are some ancient compatibility hooks back to the previous millennium. wink
Also, support of some outdated operating system versions is gone

Robert Cemper · Nov 6, 2020 go to post

Very generally speaking: There is nothing in Caché that you can't do with IRIS.
The only thing you might miss eventually, are some ancient compatibility hooks back to the previous millennium. wink

Robert Cemper · Nov 5, 2020 go to post

In general YES.
I did it myself with preIRIS  Caché.
Data and Tables and Views and Triggers are not demanding.
Migrating Stored Procedures could take a little bit more effort.
But the ability to transform Stored Procedures to Class Methods should allow also to solve tricky situations.

(I'm personally proud that over more than a decade I never lost a benchmark against Oracle)) 

Robert Cemper · Oct 29, 2020 go to post

With your service contract WRC should be able to provide you with a kit for 2015
Once restored the DB should have no problem to upgrade.

Robert Cemper · Oct 25, 2020 go to post

Hi Jeff;

all you have to do is to set the Stream location to a  Global in *TEMP Database.
Example:
 

Ok ... so this actually works:

ClassMethod GetHL7Msg(pId As %String) As %Stream.GlobalCharacter [ SqlName = GetMsg, SqlProc ]
{
    Set tHl7 = ##class(EnsLib.HL7.Message).%OpenId(pId,,.tSC)
    Throw:$$$ISERR(tSC) ..GetErr(-400, "HL7 Message with ID "_pId_" Not Found.")
    Set tMsg = ##class(%Stream.GlobalCharacter).%New()
           SET tMsg.%Location="^mtemp.JEFF"
    Set tSC = tHl7.OutputToLibraryStream(.tMsg)
    Do tHl7.%Close()
    If tSC Set tSC=tMsg.%Save()
    Throw:$$$ISERR(tSC) ..GetErr(-400, $system.Status.GetErrorText(tSC))
    Return tMsg."%%OID"
}

>>>>>

yes

Robert Cemper · Oct 24, 2020 go to post

StreamPrefetch looks related but it is totally related to the .NET end (googled SQL prefetch in .NET), 
while <INVALID OREF> is clearly an issue @Ensemble end.
I'm not too deep in the external ODBC  world but I assume that collecting the resultset and
transmitting it to .NET  [ %SYS.SQLStreamSRV ] could happen asynchronously in different processes.
So I doubted %Stream.TempCharacter which is bound to a process private Global  vs. a standard Global visible also to other processes. And only the final %Save nails it down.
I wonder if you experience the same problem if you run your query from
terminal prompt: do $system.SQL.Shell()  
This can signal if the ODBC connection plays a role at all.

Robert Cemper · Oct 24, 2020 go to post

Jeff,
if this is still happening I suggest contacting WRC. 
They have access to the sources and more diagnostic tools.