problem to load data in script for on deux rolling year

pgarcia75 — Thu, 26 Apr 2018 08:27:25 GMT

Hello

I want to load datas contained in an ORACLE table database with a loading script on 2 rolling years

I tried this script:

LOAD
date (DATETPT) as DATETPT_DTI, // Date of request
REFDTI, // Unique number ref request (link to the table
...
SQL SELECT *
FROM PTAH.PCADTI WHERE PTAH.DATETPT <NOW () AND PTAH.DATETPT> DATE_SUB (NOW (), INTERVAL 2 YEAR);

When I start loading, I have a SQL error that tells me a bracket error on the right

PS:
The statement (without the WHERE clause) works

Thanks for your help

PATRICE

Re: problem to load data in script for on deux rolling year

Gysbert_Wassenaar — Thu, 26 Apr 2018 08:40:51 GMT

Try replacing NOW() with SYSDATE or with CURRENT_DATE. Now() is a Qlikview function, which oracle doesn't understand.

topic problem to load data in script for on deux rolling year in QlikView

problem to load data in script for on deux rolling year

Re: problem to load data in script for on deux rolling year