Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;