topic Re: Calling DB function in t_map component in Talend Studio

Calling DB function in t_map component

_AnonymousUser — Wed, 26 Sep 2012 06:16:00 GMT

Hi,
I am new to Talend and using version 5.1.
I am using oracle and have a function created in DB. Is there a way I can call it and use it in t_Map component directly?
If not, How can I use it?
Please advice.

Regards,
HPR

Re: Calling DB function in t_map component

Anonymous — Wed, 26 Sep 2012 07:54:19 GMT

Hi, HPR
The tMap component cannot support that calling and using a created function in DB directly, if your requirement is just to call the function in DB, you can use the component tOracleSP or tMysqlSP instead to meet your needs.

Best Regards
Sabrina

Re: Calling DB function in t_map component

_AnonymousUser — Wed, 26 Sep 2012 08:44:50 GMT

Hi,
My requirement is to call the DB function to populate a column in the target table for every single record being inserted to that table.
Can you please help to achieve this?

Re: Calling DB function in t_map component

alevy — Fri, 28 Sep 2012 06:03:11 GMT

If the function does not need to take a parameter from the other data being inserted then use the Additional Columns advanced option of tOracleOutput.
If you do need to pass a parameter from the other data then use tOracleRow with a SELECT statement to get the value and the "Propagate QUERY's recordset" advanced option to populate that value into the flow to tOracleOutput.