Can tDB2row be used as a lookup to tMap

Four Stars

Can tDB2row be used as a lookup to tMap

I have the following design

 

tDB2Input -> tmap -> tlogRow

                         |

                      lookup

                          |

                      tDB2row

 

- I am using tDB2row to be able to use preparedStatement. I realize that I can design the same with tDB2Input -> tDB2Row -> tParseRecordSet -> tLogRow, however, this design seems to be doing an equivalent of 'inner join' but I need the 'outer join' behavior.

- In the former design (tDB2Row as lookup), when I looked at the code I did not see a resultSet object extracted from the preparedStatement object. The query is executed but the values are not being extracted.

- I want to use the tDB2Row component so that I can use the PreparedStatement option which is more efficient than a DB2Input lookup with a 'load each row' option.

 

Any help is much appreciated


Accepted Solutions
Community Manager

Re: Can tDB2row be used as a lookup to tMap

Hello
You need to use a tParseRecordSet after tDB2Row to extract the values from the prepraedStatement object.
tDB2Input -> tmap -> tlogRow
                        |
                  lookup
                        |
tDB2row--main--tParseRecordSet

Regards
Shong

----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re: Can tDB2row be used as a lookup to tMap

Hello
You need to use a tParseRecordSet after tDB2Row to extract the values from the prepraedStatement object.
tDB2Input -> tmap -> tlogRow
                        |
                  lookup
                        |
tDB2row--main--tParseRecordSet

Regards
Shong

----------------------------------------------------------
Talend | Data Agility for Modern Business
Four Stars

Re: Can tDB2row be used as a lookup to tMap

This worked. Thank you

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads