topic Re: Error in sql dynamic query in Talend Studio

Error in sql dynamic query

Anonymous — Wed, 27 Mar 2019 17:42:40 GMT

I have a problem in this job.

To resume, I have a table "A" wich contains a fild named " prix " and the value is the result of an sql query this contains where conditions from another table and filds from "A".

I don't have a error in the execution but there is no result for the query and I should be !

Any suggestion ?

Re: Error in sql dynamic query

DataTeam1 — Wed, 27 Mar 2019 22:12:28 GMT

Adde tJava component and link TUNSTORE with tJava using OnComponent OK

In tJava use Query property from TUNSTORE as bellow:

System.out.println(((String)globalMap.get("tDBInput_3_QUERY")));

Of course change tDBInput_3 with your component ID

Run you job and check the select you will see in the console directly in database.