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

  • Data Integration
1 ACCEPTED SOLUTION

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
2 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