topic Re: insert a row with context variables in Talend Studio

insert a row with context variables

Anonymous — Sat, 16 Nov 2024 03:53:04 GMT

Hello everyone,

I have some context variables that I need to put in a database so that at each execution of the job a new row is created with these variables. I'm not sure if I'm using it right but with a

tMSSqlconnection ==(On component OK)==> tMSSqlrow ==(Main)==> tMSSqloutput

there is no new line in my database .

the query in my tMSSqlrow ;

INSERT INTO table1 (col1, col2, col3) values (StringHandling.SQUOTE(context.var1) ,CONVERT(DATETIME, StringHandling.SQUOTE(context.var2), 20), StringHandling.SQUOTE(context.var3))

I'm I doing something wrong ?

Re: insert a row with context variables

Anonymous — Mon, 09 Dec 2019 21:22:01 GMT

did you commit

Re: insert a row with context variables

tnewbie — Mon, 09 Dec 2019 21:43:11 GMT

tFixedFlowInput would do the job...please check the attachment

capture_contexts_in_DB.png

Re: insert a row with context variables

vapukov — Mon, 09 Dec 2019 22:21:00 GMT

Hi,

you need prepare sql by concatenating string:

"INSERT INTO table1 (col1, col2, col3) values ("+StringHandling.SQUOTE(context.var1)+",CONVERT(DATETIME, "+StringHandling.SQUOTE(context.var2)+", 20), "+StringHandling.SQUOTE(context.var3)+")"