Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am have problem, when I use the variable
let vExecTime='2015-03-25' in a load sql select statment,
sql where statement (WHERE MODIFIED < '$(ThisExecTime)')
return 0 records from sql table while when replace variable with '2015-03-25' sql select statmen works?
MODIFIED should be in YYYY-MM-DD format !
Also check < or > depending upon your requirements.
Is it because you used wrong variable name in Sql??
(let vExecTime='2015-03-25' in a load sql select statment,)
sql where statement (WHERE MODIFIED < '$(ThisExecTime)')
Try sql where statement (WHERE MODIFIED < '$(vExecTime)')
anbu got it right! that was the fix;
I am trying to create a QVW that does incremental loads of large SQL tables that get updated daily.
The scripting in Re: Re: Incremental Load Script
for case 4 worked fine until I added a second set of data (different SQL table) to save a 2nd QVD. The script runs correctly for the 1st incremental load and creates an updated QVD then drops/ at end of second table right as it starts to store the 2nd QVD that has an incremental load with same scripting in case 2 (Load Insert/Update/Delete).
anbu got it right! that was the fix;
I am trying to create a QVW that does incremental loads of large SQL tables that get updated daily.
The scripting in Re: Re: Incremental Load Script
for case 4 worked fine until I added a second set of data (different SQL table) to save a 2nd QVD. The script runs correctly for the 1st incremental load and creates an updated QVD then drops/ at end of second table right as it starts to store the 2nd QVD that has an incremental load with same scripting in case 4 (Load Insert/Update/Delete). typo both are case 4 incremental loads.