I use action "DB Execute Query" from JDBC Action Pack for execute SQL-query. After execution the action I can see result of query in Report. But I can't find the way to read this result and write it to variable. Can anybody explain me how I can read and write result of query execution?
Thanks in advance.
Process the job output using PREP_PROCESS_REPORT, and write rows to the VARA using PUT_VAR.
Michael thak you for your answer.
Alternatively, you might be able to reshape your solution to put the SQL directly into a SQL variable so you won't have to write the script to process the report. Very likely, your solution will be faster when using a SQL variable, since you won't have the extra step of processing the report. If that is not possible, then Michael's answer is your only choice.
Leonard thak you for your answer