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

Hi,

 

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.

Outcomes