Hi,

I still didn't find out how to do such a thing :
Say I am processing an input file and along the subprocess I need to perform a dynamic sql select to enrich my flow.

In such a case the sql lookups are loaded at the beginning of the file processing, so that it does not fit since it's kind of a 'static' sql select. Same issue with the new tJoin.
The base problem of lookups is that it is static data.

I found a workaround processing the end of the subprocess in a child job (using tRunJob) but it is not always feasible. Another workaround would be to split my input file in multiple input files of one line each, but I really try to avoid that.

The tDBRow Component could do the trick, but from the generated code I see that it does not deal at all with the incoming/outcoming flows. Moreover both flows have to be identical...

In fact I need something like :

Flow A --> MagicComponent performing some sql select (optionally using part of Flow A in the where clause) --> Flow B containing Some columns of flow A + some columns of the sql ResultSet

Any light appreciated