Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Your variable should hold exactly the same format of timestamp as it's comparison field. Then try with single quotes, like:
WHERE DBTIMESTAMP> '$(vVariable)'
i am agree with tresesco but i will suggets to keep same format of date in vVariable too
hope this helps