Hello,
I wrote following script for incremental load of KEPH and getting script error.
LET vLoadDaysFrom = Date(Today()-6, 'YYYYMMDD');
KEKO:
Load *;
SQL SELECT KALNR CPUDT TOPKA FROM KEKO
WHERE TOPKA EQ 'X' and CPUDT EQ '$(vLoadDaysFrom)' ;
STORE KEKO into $(QVDPath)\KEKO.QVD;
KEPH:
Concatenate
Load *;
SELECT MANDT KALNR BZOBJ KALKA KADKY TVERS BWVAR KKZMA PATNR KKZMM LOSFX KEART KKZST DIPA FROM KEPH
WHERE KKZST NE 'X' ;
Load * Resident KEKO WHERE CPUDT = '$(vLoadDaysFrom)' ;
DROP TABLE KEKO;
Concatenate (KEPH)
LOAD * FROM (qvd) ;
STORE KEPH into $(QVDPath)\KEPH - Kopie.QVD;
DROP TABLE KEPH;