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

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now