how to pass values from a dynamic query in a child job to a parent job
Hi team,
i am new to talend. can you please help me passing values from a dynamic query in a child job to a parent job.
For example, my child job first runs a query such as select count(*) from emp where name like '%a%';.
Next time the query might change to something like select empname,empid from emp where deptno=n;
how to pass the values returned from the child job query to the parent job. i tried with tbufferoutput but it doesnt support dynamic schema. my database is as400
The query might be different each time? tBufferOutput does not support dynamic schema, you have to use several tBufferOutput components to map different schema for each query.
Dbinput->tlogrow ->tjavarow ->tbufferoutput and I am getting the values. Now I need to send these query results in a mail. I tried with tjavarow but it displays only last row.
