Hi everyone,

I’m using EnsLib.SQL.OutboundAdapter in my InterSystems Ensemble operation to execute an insert statement in Sql Server Management Studio 20. While inline queries (e.g., constructing the query string with _ concatenation) work fine, I'm facing issues when trying to use parameterized queries.

Serialized JSON: {"CHI":"2894","Forename":"Janis"}

Include Ensemble

Class TNHS.Operation.RDS.PatientOperation Extends Ens.BusinessOperation{

Parameter ADAPTER = "EnsLib.SQL.OutboundAdapter";
Property Adapter As EnsLib.SQL.OutboundAdapter;
Method OnMessage(pRequest As TNHS.Data.RDS.Patient) As %Status
{

        $$$TRACE("Inside OnMessage..  method")

        Set patientJSON = pRequest.ToJSON()

        $$$TRACE("Serialized JSON: "_patientJSON)

        set sql="INSERT INTO RawData (DrugDetails) VALUES (?)"
        //perform the Insert
        set tSC = ..Adapter.ExecuteUpdate(.nrows,sql,patientJSON)        

         If $$$ISERR(tSC) {

        $$$LOGSTATUS(tSC) // Log error if insertion fails
        Quit tSC

        }

       Quit $$$OK
}

}

•  Is there a specific way to pass parameters using objectscript to sql server
• Are there any known limitations or special configurations needed for parameterized queries with this adapter?
• Could this be an issue with the SQL driver or database itself?

Any suggestions or best practices would be greatly appreciated. Thanks in advance!