Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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));
In any case, use single quotes:
WHERE LastModifiedDate >='$(vLastExecTime)' and LastModifiedDate < '$(vSFDCExecTime)';
And - what is the difference between the systems?
Hi,
vLatExecTime is the variable then check the variable declaration while running in other system
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));