topic Re: parse a query into a variable in Talend Studio

parse a query into a variable

DrGenious — Wed, 11 Mar 2020 09:24:51 GMT

Hey,

Is it possible to have this code in talend?

//Inialize Id
query = "SELECT id, name " +
" FROM total_type_id " +
" ORDER BY name ,id";
ps = conn.prepareStatement(query);
rs = ps.executeQuery();
Have I to to do it like above inside the query component? Or I can in a tjava component just put this code an the name of the db?

Re: parse a query into a variable

Anonymous — Wed, 11 Mar 2020 15:27:01 GMT

Hi,

Can you explain why you cannot just write the query directly in a tDBInput component?

Re: parse a query into a variable

DrGenious — Thu, 12 Mar 2020 09:12:04 GMT

@tehLurdUfEngmer Hi. The reason is because I want to store the result into a variable.