assign tMSSqlRow value to context variable?

Anonymous — Fri, 16 Mar 2018 13:06:39 GMT

Hi,

how to assign tMSSqlRow value to context variable ?

Below is my query is written in tMSSqlRow_2. Need to read the value from tMSSqlRow_2 and assign to context variable. how to achieve this? Please help

Query :

"
begin
declare
@srcid int,
@sessionid int;

select @srcid=srcid from dbo.src_tbl where src_name='xxx';

select sessionid from session_tbl where srcid=@srcid and loaddate='2011-12-20'
end
"

Additional info:

session_tble structure:
sessionid int IDENTITY(-3333333,1) not null ,
srcid int,
loaddate date

src_tbl structure:

src_id int,
src_name varchar(500)

Context:

Name Type Value (default)

SessionID Int -9999999

i have followed this :

tMSSqlConnection -->tMSSqlRow_1 --OnComponentOK---> tMSSqlRow_2 ---main--->tJavaRow-->tLogRow

i have written above code in tMSSqlRow_2, in tMSSqlRow_1 ("sessionid") is getting populated.

When i run job it is writtening null.

Please help.

Thanks

Re: assign tMSSqlRow value to context variable?

TRF — Sat, 17 Mar 2018 21:15:04 GMT

Hi,
What's in tJavaRow?

Re: assign tMSSqlRow value to context variable?

Anonymous — Sun, 18 Mar 2018 02:23:02 GMT

Can I ask why you are using the tMSSqlRow for this? From what I have seen of your problem, it would be a lot more straight forward to use the tMSSqlInput to read the data and the tMSSqlOutput to write the data.

topic Re: assign tMSSqlRow value to context variable? in Talend Studio

assign tMSSqlRow value to context variable?

Re: assign tMSSqlRow value to context variable?

Re: assign tMSSqlRow value to context variable?