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.