I have created row3.diff (integer field) and try to pass into query like
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!
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.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.