topic Re: Incremental Load from Oracle and Date issues in QlikView

Incremental Load from Oracle and Date issues

Tue, 24 Jun 2014 07:02:41 GMT

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

tresB — Tue, 24 Jun 2014 07:06:18 GMT

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

WHERE DBTIMESTAMP> '$(vVariable)'

SunilChauhan — Tue, 24 Jun 2014 07:13:38 GMT

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

hope this helps