Dear All,
I had copied a little piece of scrpt from a user in this community,
and I ' ve made some changes on it
my purpose:
1. load old data from QVD
2. find the last load time
3. incrementally load data from DB via ODBC
my script:
1.
Temp:
Load * from (qvd);
2.
Res:
Load MAX(XF_LASTMODTIME) as maxDate resident Temp;
et vMax = chr(39)&DATE(peek('maxDate',-1,Temp),'YYYY-MM-DD HH.MM.SS')&chr(39);
3.
ODBC CONNECT TO [TNT11G;DBQ=TNT11G] (XUserId is GbHDbJRKRBSWUAJM, XPassword is YQQZSJRKRBSWUAJW);
New:
select * from xf_itemdm where xf_lastmodtime > TO_DATE($(vMax),'YYYY-MM-DD HH24.MI.SS');
for step 1, 2, the debugger tell me that the corresponding tabes' (temp, res) loading time and its number of rows returned
how ever, for step 3, it told me the load time of "Temp" instead of "New"- my expection.
was it really reloading data from database? or it was misled to load from the "Temp" table?
Thx a lot!