========================================================
LET vDeltaBegins=Timestamp(Now(1),'YYYY-MM-DD hh:mm:ss');
DELTA_PSA:
LOAD
SERIES,
LastTime,
LoadType,
LoadScript,
TotalReloadTime
FROM $(QvdPath)\DELTA_PSA.QVD (Qvd);
DELTA_PSA1:
LOAD
MAX(SERIES) AS LastSeriesNo
RESIDENT DELTA_PSA;
DELTA_PSA2:
LOAD
Timestamp(MAX(LastTime),'YYYY-MM-DD hh:mm:ss') AS LastReloadTime
RESIDENT DELTA_PSA;
//where LoadScript='$(VPARAM)';
LET vLastSeriesNo=peek('LastSeriesNo',-1,'DELTA_PSA1');
LET vLastSeriesNo=$(vLastSeriesNo)+1;
LET vLastReloadTime=TIMESTAMP(PEEK('LastReloadTime',-1,'DELTA_PSA2'),'YYYY-MM-DD hh:mm:ss');
LET vLoadScript='$(VPARAM)';
DROP TABLE DELTA_PSA,DELTA_PSA1,DELTA_PSA2;
Hi All,
Can u plz tell me what is the use of delta load in above case.
thanks