Yuri Marx · Jan 3, 2022

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
0 121
Discussion (3)2
Log in or sign up to continue

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.