AnsweredAssumed Answered

Executing multiple SQL queries in single JDBC step

Question asked by SKavitha on Jul 10, 2018
Latest reply on Jul 11, 2018 by SKavitha



I need to execute multiple SQL queries in single JDBC step(SQL Database Execution) step. I separated each query with ; but not getting expected response. Query 1 does not have any result set and query 2 returns return set.


Query used in JDBC step:


alter session set current_schema = ENVI;
select number from policy where polnum='123';


Kindly guide me on this.