Ask Your Question

Revision history [back]

return multiple resultsets with jdbc query consumer

I have stored procedure which return multiple result sets from the database. how can I them from jdbc consumer I am able only to get first one but not all

return multiple resultsets with jdbc query consumer

I have stored procedure which return multiple result sets from the database. how can I them from jdbc consumer I am able only to get first one but not allall. The procedures return with multiple ECHO select statements SDC return only the result of first ECHO not the rest, I tried with python script it returned multiple results. The JDBC consumer is with default configuration.