go to post Guillaume Rongier · Aug 1, 2019 Hi Julian,On what version of InterSystems product you are working on ?If it's on Ensemble, check out ENSDEMO namespaces, you will have an example of what you are looking for with this production : Demo.DICOM.Production.StorageLocalIf you are on Iris for health you can install EnsDemo with the help of this git : https://github.com/grongierisc/InstallEnsDemoHealth
go to post Guillaume Rongier · Apr 18, 2019 If you want some examples, benchmarks and ready to use adaptor you can have a look at this :IRIS/Ensemble as an ETLOpen ExchangeBathSqlOutboundAdaptorWith this adaptor you can expect to be more than 10 times faster. (this github provides you examples).
go to post Guillaume Rongier · Jan 22, 2019 My guess is that you are concatenating string with the operator "&" (AND) instead of "_".If you do so, ObjectScript will cast your string as boolean false, the result of (false and false and false) equals 0, the result you see in your question. Method PatientInfo(ID As %String) As %Status { #dim status as %Status=$$$OK SET myquery="SELECT GUID, IDType,IDValue FROM MergeHyland.TypeTwoDimesionCollection WHERE GUID ="_ID SET rset=##class(%ResultSet.SQL).%Prepare(myquery,.err,"") WHILE rset.%Next() { WRITE !,rset.GUID _ ":" _ rset.IDType_ ":" _ rset.IDValue } WRITE "End of data" return status }
go to post Guillaume Rongier · Jan 7, 2019 Hi Eduardo,My comprehension of your use of Git and Ensemble is that all devs build on the same sever like this :This is not the way to go.I recommend to use this model where every devs have there own server :
go to post Guillaume Rongier · May 31, 2017 Hi, Have you try to type your SQL parameters : set param(i,"SqlType") = 12 //12 for SQL_VarCharI hope this will help you.