unknown statement WHERE LastModifiedDate >=$(vLastExecTime) and LastModifiedDate < $(vSFDCExecTime);// and IsDeleted = false;

[#1]

The following statement had no problem on my system,

WHERE LastModifiedDate >=$(vLastExecTime) and LastModifiedDate < $(vSFDCExecTime);

but when i run it on different system ,the error is

unknown statement

WHERE LastModifiedDate >=$(vLastExecTime) and LastModifiedDate < $(vSFDCExecTime);

[Anonymous]

In any case, use single quotes:

WHERE LastModifiedDate >='$(vLastExecTime)' and LastModifiedDate < '$(vSFDCExecTime)';

And - what is the difference between the systems?

[#3]

Hi,

vLatExecTime is the variable then check the variable declaration while running in other system

[#4 · Accepted solution]

The error

Unknown statement

WHERE Not(Exists (Id))

due to

LOAD *

  FROM $(vIntegratedQVDPath)SFDC_$(tableName).qvd (qvd); // due to semi colon here which ends the statement

  WHERE Not(Exists (Id));