Error in sql dynamic query

[Anonymous]

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 ?

[DataTeam1]

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.