how to read rows returned from function with tdbsp component

Anonymous — Sat, 16 Nov 2024 04:29:30 GMT

Hi,

I am trying to use a function in tdbsp component and want to use the result returned by function in tdbrow component(update statement).

tdbsp(function)----->tdbrow(update)

I am getting null value as a function result and hence update is not working as expected but am able to print the result returned by function in tlogrow.

Please suggest how can i do this.

Re: how to read rows returned from function with tdbsp component

vapukov — Thu, 03 Oct 2019 22:31:49 GMT

tDBSP do not create a dataflow, you can use tParseRecordSet to extract data - https://help.talend.com/reader/WQvDLxgl6A~aKwyHRPy4mQ/8v7UKcrJqPWj_qBKWYqyxg

but often the more simple way - just to use tDBInput instead of tDBSP if you need proceed returned data

the source of tDBInput could be any query (not only SELECT col1 FROM tableX), such as:

- exec udp_MyStoredProcedure X Y Z (call udp_MyStoredProcedure)

- SELECT my_func(X,Y)

related to your parallel question - you can use a prepared query with variables stored by tFlowToIterate to prepare proper call:

"EXEC udp_MyProcedure "+(String)globalMap.get("row1.col1") + " " + (Long)globalMap.get("row1.col2")

topic how to read rows returned from function with tdbsp component in Talend Studio

how to read rows returned from function with tdbsp component

Re: how to read rows returned from function with tdbsp component