How to pass the output of one oracle sql to other oracle sql in talend

[Anonymous]

I am trying to create the 2 sqls. In first sql my output will be the last runtime of the Table and in another sql I want to feed this output as input for 2nd sql. I am trying to pass the variable through Tflow to iterate component. But here it is taking the default date (Java.util.date) as the input to my second sql and getting the error as invalid relation operator.
I need to pass the date format as "dd-MMM-YY hh:mm:ss:ssz" in the second sql but whereas from the tflow to iterate component giving the dateformat as "Mon Apr 08 22:00:06 IST 2019". 

Please suggest how to fix this in flowto iterate component and provide the suggestion on if any other component is there to iterate the values ?

[Anonymous]

Hi,

I had tried the same logic. It is working as expected. Thank you for your suggestion
I have one more question related to updating the DB. Is it possible to update the values in the table by using TDBInput component? If I have to use TDBOutput component then, in that case how to iterate the timestamp value to this component
I can't able to do the connection from TFlowto Iterate to TDBOutput...

[vapukov · Accepted solution]

Hi

you cannot connect direct to tDBOutput, and you cannot update in tDBInput

but you can:

- connect tDBInput to tDBOutput for update

- use tDBRow instead of tDBOutput, the you can run any query UPDATE/DELETE and etc

[Anonymous]

Hi,

Thank you for your suggestion.