Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Incremental Load from Oracle and Date issues

Hi all,

I'm writing an incremental load script to load a table from oracle.

my Water mark is a DBTIMESTAMP from oracle.

When I load from the latest QVD the max DBTIMESTAMP I save it into a variable in the script.

Then I try to run a SQL query on the oracle DB and do an expression:

WHERE DBTIMESTAMP> vVariable

I get an error: expected a date, got a number

when I get the max DBTIMESTAMP from the QVD I put in in the date function but still it doesn't work.

Can someone who has dealt with oracle loads assist me?

Thanks,

Boris

2 Replies
MVP
MVP

Re: Incremental Load from Oracle and Date issues

Your variable should hold exactly the same format of timestamp as it's comparison field. Then try with single quotes, like:

WHERE DBTIMESTAMP> '$(vVariable)'

chauhans85
Esteemed Contributor

Re: Incremental Load from Oracle and Date issues

i am agree with tresesco but i will suggets to keep same format of date in vVariable too

hope this helps

Community Browser