The only way to insert info into a different database is to configure a sql gateway connection by JDBC and execute the SQL with the insert.

Just the first line?

set str=##class(%Stream.FileCharacter).%New()
do str.LinkToFile("c:\myfolder\file.csv")
set $listbuild(VALUE1,VALUE2,VALUE3)=$listfromstring(str.ReadLine())

%Stream.FileBinaryGzip extends %Stream.FileBinary, so they are practically equals, the only difference is the gzip compression and maybe a read process a bit slower with Gzip than just with FileBinary (and this is more a feeling than a fact).

Hi @Michael Wood ! What is the type of context.FHIRResponse.Body? Interoperability with FHIR usually works with HS.FHIRServer.Interop.Response class in wich the JSON FHIR is saved as a Stream.

Could you tell us something else about what are you doing?

I'm assuming that every new patient received in a HL7 message has to be created as IRIS user so in the BP I'm creating the user and assigning it to the new task.

As the error says, you have to install the JDK 11 on your computer from here and configure JAVA_HOME system environment variable:

Perhaps you have already configured it but with newer version.

From the official documentation: 

The compact database operation is designed to run concurrently with normal database activity. The operation does consume some system resources, however, and may not complete if the system is under extremely high load. For these reasons, InterSystems recommends running this and other database reorganization operations (including compacting and defragmenting globals) during off-peak hours, and running only one such operation on a system at a time.

https://docs.intersystems.com/iris20241/csp/docbook/DocBook.UI.Page.cls…

You can do it by hand, specifying in the JDBC url used the schema to connect, so you have to disconnect from the previous connection and connect again with the new **CORRECTION** namespace:

jdbc:CACHE://127.0.0.1:1972/NAMESPACE1--> jdbc:CACHE://127.0.0.1:1972/NAMESPACE2

The documentation is pretty clear, you have to include the external table as a subquery:

FROM Sample.Person,(SELECT * FROM Mylink.Person)

That means that you have to modify your view to use the external table in that way.