topic Re: tDBRow(MySQL) - NamedParameter in Talend Studio

tDBRow(MySQL) - NamedParameter

Anonymous — Tue, 29 Oct 2019 07:13:46 GMT

Hi,

I want to execute a SQL query with the tDBRow(MySQL) component. How can i define the two named parameters ?

select * from people where (first_name = :name or last_name = :name) and address = :address")

Any ideas ?

Re: tDBRow(MySQL) - NamedParameter

fdenis — Tue, 29 Oct 2019 08:28:35 GMT

on your sql query you can insert java code globalMap value or context value:
"select * from people where (first_name = "+ globalMap.get("yourGlobalVar") +" or last_name = " + context.oneValue + ") and address = " + any java code + " )"