I have this job, my input file data contains a lot of sql statement like DELETE, UPDATE, INSERT etc., and is separated by semicolon(;).
I want to fetch the result of the final number of rows affected by the query. I tried doing this, by selecting “Propagate QUERY's recordset” in the advanced settings of tJDBCRow component.
But when I am trying to execute this job its throwing me the following error:
The executeQuery method must return a result set
Can someone help me out, in fetching the output for each statement? Thank you.