Difference between an TAS400ROW and TAS400INPUT

[rwnetwork]

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]

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]

Thank you so much!

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