Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I had incremental date: Last Update Date in M/DD/YYYY hh:mm:ss TT format.
Example: 8/11/2009 10:37:00 AM
While taking incremental Load;
Load * from table where [Last Update Date] >= $(vThisExeTime) and [Last Update Date] <=$(vLastExeTime)
where vThisExeTime= chr(39) & Date(now(), 'M/DD/YYYY hh:mm:ss TT') & chr(39)
and the same is storing at end of the entire script into vLastExeTime.
But I am getting error: Attached image
I haven't worked with Sybase, but from the doc it appears timestamps should be of the ISO 8601 standard format of YYYY-MM-DD hh:mm:ss. So try presenting your SQL WHERE arguments in that format.
-Rob
Try putting single quotes around variable expansion, like: ' $(vThisExeTime)'
Edit: you might have to redefine your variable excluding chr(39)
Thanks TRESESCO for your idea... but unfortunately not working!
I haven't worked with Sybase, but from the doc it appears timestamps should be of the ISO 8601 standard format of YYYY-MM-DD hh:mm:ss. So try presenting your SQL WHERE arguments in that format.
-Rob
Possibly a format mismatch. Please be doubly sure of it; check little things like, if any space difference, or so.
Hi Rob,
you are wonderful, even if you haven't worked on sybase, your idea worked. . .!
Thanks brother!!! Thanks!