Difference between an TAS400ROW and TAS400INPUT

Highlighted
Seven Stars

Difference between an TAS400ROW and TAS400INPUT

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!

 

Highlighted
Forteen Stars

Re: Difference between an TAS400ROW and TAS400INPUT

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

 

-----------
Highlighted
Seven Stars

Re: Difference between an TAS400ROW and TAS400INPUT

Thank you so much!

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

 

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now