Call java programs from sql instructions (like new load data)
Is it possible to call java programs inside SQL statements, like the new LOAD Data, or is this just internal?
Product version: IRIS 2021.2
Discussion (3)2
Log in or sign up to continue
https://test.community.intersystems.com/post/call-java-programs-sql-instructions-new-load-data
As you can project ANY ClassMethod as SQL PROCEDURE I see no obvious limit to your intention.
Call yoru JAVA from IRIS with any of the available interfaces (or nodjs, or Python, or .....)
inside a ClassMethod that you present them as SQL_PROCEDURE.
But LOAD DATA is not a ClassMethod exposed as a SQL procedure
You can. Two different ways but both utilize the External Java Server with gateway connections. That is the same mechanism employed by LOAD DATA. If you have an example of what you want to do then I can provide you with a demo - using both options.