parse a query into a variable

[DrGenious]

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?

[Anonymous]

Hi,

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

[DrGenious]

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