Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I am loading the data from sql server,i have a field callled DOJ and the datatype is date ,that means it displays date
as yyyy-mm-dd,..while i am doing incremental load it gives me an error ..the error is operand type clash date is incompatile
with int.my script for incremental load is
IncLoad:
LOAD id,
name,
date(Selectdate) as Selectdate;
SQL SELECT *
FROM NORTHWND.dbo.IncTest where Selectdate>=$(vModDate);
Selectdate
FROM
(qvd) where not exists(id);
could anyone suggest me..
Try the variable with single-quotes: Selectdate>='$(vModDate)'
- Marcus