SQl Query Retreiving Data from globalmap.get("") function. JAVA ?

One Star

SQl Query Retreiving Data from globalmap.get("") function. JAVA ?

SYNTAX is my prob, but im not sure where. My capitolization is correct.
java.sql.ResultSet rs_tMSSqlInput_2 = stmt_tMSSqlInput_2.executeQuery("SELECT dbo.BASE_MODULE_NUMS.MATNR,dbo.BASE_MODULE_NUMS.MAKTX FROM dbo.BASE_MODULE_NUMS where dbo.BASE_MODULE_NUMS.MATNR ="((String)globalMap.get("row2.MATNR"))");
Thanks

Re: SQl Query Retreiving Data from globalmap.get("") function. JAVA ?

you need to concatenate strings in Java.
where dbo.BASE_MODULE_NUMS.MATNR = " + (String)globalMap.get("row2.MATNR"));

Talend also supports Perl which is a bit more "user friendly" when it comes to string handling.