Can tDB2row be used as a lookup to tMap

[akakuman]

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

[Anonymous · Accepted solution]

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

[akakuman]

This worked. Thank you