So, I've created a DataLake view as...
CREATE OR REPLACE TEMPORARY VIEW CHANGED_POS
I then want to use the results of this view in my SQL delete statement, deleting records from SQL Server table.
I have written the following, but it appears I can't reference CHANGED_POS in my sql statement...
val connection = DriverManager.getConnection(jdbcUrl, jdbcUsername, jdbcPassword)
val stmt = connection.createStatement()
val sql = "delete from LANDING_MDP.ZOPEN_PO where EBELN IN (SELECT EBELN FROM CHANGED_POS)"