topic Re: Difference between an TAS400ROW and TAS400INPUT in Talend Studio

Difference between an TAS400ROW and TAS400INPUT

rwnetwork — Thu, 23 Jan 2020 19:23:49 GMT

Hi all,

Can someone explain to me in simple terms what the difference is between the tas400row and tas400 input components please?

I will use one or the other thinking I chose the correct one, but then I find myself being incorrect.

Thank you much!

vapukov — Wed, 29 Jan 2020 00:33:22 GMT

Hi,

for any database:

*_Input - read data from the database and send it to the next component, it could use more complicated code but mostly - SELECT col_a, col_b FROM myTable
*_Row - execute any SQL (such as UPDATE/DELETE/etc) with or without using input data flow, you can execute SQL with parameters for any incoming row or you can use it as a standalone component for run something like - DELETE FROM myTable
*_Row by default do not send any data to following components

rwnetwork — Wed, 29 Jan 2020 17:53:05 GMT

Thank you so much!

This was a such a great way of laying it out. Makes much more sense!