Incremental Load from Oracle and Date issues

[#1]

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

[tresesco]

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]

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

hope this helps