topic Re: passing constant value to a DB function in Talend Studio

passing constant value to a DB function

Anonymous — Sat, 16 Nov 2024 04:26:47 GMT

Hi ,

I have a DB function which takes two parameters, one is the count and other is constant string(hard coded value). Count variable is calculated from tAggregateRow component which i can pass it to DB function in tOracleSP component (attached for reference). But how do i pass a constant string value as second parameter. Please suggest!!

Re: passing constant value to a DB function

TRF — Tue, 08 Oct 2019 06:07:54 GMT

Add something like a tMap after tAggregateRow to add the missing column to your schema with the expected value

Re: passing constant value to a DB function

Anonymous — Tue, 08 Oct 2019 12:48:09 GMT

Hi,

Thanks for response, i would like to avoid using tMap component just to
create a constant string field. Any other way to pass a hard coded string
to a procedure/function?

Re: passing constant value to a DB function

TRF — Tue, 08 Oct 2019 12:58:28 GMT

As soon as you need it in your schema, you don't have choice, you may change tMap by tJavaRow but it's not really different. You may also use tFilterColumns to add a column by you need something else to populate it.

Re: passing constant value to a DB function

Anonymous — Tue, 08 Oct 2019 13:03:30 GMT

Thank you, will work on it