Incremental

[abhaysingh]

I want to pick last reload time in incremental load.. Can any one help me in this

thanks..

[its_anandrjs]

Use variables for that

Let vLastReload = NOW();

Or

Let vLastReload = ReloadTime();

and use this variable in the incremental load script

Load *

From Location Where  Datefield > $(vLastReload);

[#3]

Dear Abhay,

You also try his way , if you have datetime field in your Database table....

//Step 1------

MaxData:

LOAD

     DATIME

FROM  ..\X.qvd(qvd);

//step 2...........

Sorting:

Load

DATIME as MaxDate

Resident MaxData order by DATIME Desc;

Let MaxTimeStamp=Peek('MaxDate',0);

Let MinDate=Peek('MaxDate',-1);

Let MaxTIMESTAMP=Timestamp($(#MaxTimeStamp),'YYYY-MM-DD-hh.mm.ss.ffffff');

Drop Table Sorting,MaxData;

use last variable in your query.

Warm Regards

Vimlesh Gupta

[PradeepReddy]

As suggested by anand, you can use the 'ReloadTime()' function

ReloadTime() : Returns a time stamp for when the script last finished re-executing.