topic Re: tMSSqlRow - How to use schema variables in query in Talend Studio

tMSSqlRow - How to use schema variables in query

Anonymous — Sat, 22 Jul 2017 07:40:49 GMT

Hi,

I have tMSSqlRow component with 2 variables in schema, named UPC and ITEM_NO.

The tMSSqlRow is holding the output of tMap as follows :

How can I use the schema variables in Query ? i.e. in place of schema.ITEM_NO and schema.UPC ?

Thank you !

vapukov — Sat, 22 Jul 2017 13:24:42 GMT

You must use prepared statements - check on Advanced properties of tMSSQLRow

change parameters to ?

and assign properties on Advanced Tab

in You case it will be

... SET ERP_WEST = ? WHERE UPC = ? ...

and parameters
index 1 - updae1.ITEM_NO
index 2 - updae1.UPC

updae1 - same as on picture, think it update1