Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a job that retrieves the data from a SQL table (tDBInput) and it iterates through the rows (tFlowIterate) to modify the data by using a code routine in tJavaRow. Once the data is modified, each row is then inserted into an SQL table inside a different database (tDBOutput).
When running the job, I found that it is taking a long time to insert each row. Is there a way to store the modified rows in a temporary table/Hash table udring the iteration, and on SubJobOk insert all rows in the table at one go ?
RG
Hi , in your case you can iterate on a buffer.( see tbuffer component or thash component). And then when all your row are iterated Send all the buffer in the tdboutput.
Hi , in your case you can iterate on a buffer.( see tbuffer component or thash component). And then when all your row are iterated Send all the buffer in the tdboutput.
I used the tbuffer component and it worked like a charm. The job is much faster now.
Thanks for your help.