((Integer)globalMap.get()) double quote error

Four Stars

((Integer)globalMap.get()) double quote error


I have created row3.diff (integer field) and try to pass into query like

update tmp
set somevalue='Y'
where tmp.inDate < dateadd(day, ((Integer)globalMap.get("row3.diff")), tmp.outDate)


job cannot run and show error:

syntax error at or near "globalMap" 

I have tried to change to


where tmp.inDate < dateadd(day, '"+((Integer)globalMap.get("row3.diff"))+"', tmp.outDate)

nothing works. Can anybody help me how I should modify?


Thank you very much!





Sixteen Stars

Re: ((Integer)globalMap.get()) double quote error

I believe you are using the dateadd function incorrectly. There are no quotes around "day", yet you have single quotes around the diff value. Can you copy and paste your entire query (with all quotes) and let us know which database you are using. I'm assuming it is Oracle?




Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.