Hi,
I created a Generic Extractor on GLPCA and it seems like I have the code working fine for either a full or an Init/Delta. Now I'd like to know what I might have to do to code for an Init without data? Surely someone must have done this?
**** FULL LOAD IF ENDDATE = '00000000'. OPEN CURSOR WITH HOLD S_CURSOR FOR SELECT * FROM GLPCA WHERE RYEAR IN LR_RYEAR AND POPER IN LR_POPER. ELSE. **** DELTA LOAD OPEN CURSOR WITH HOLD S_CURSOR FOR SELECT * FROM GLPCA WHERE RYEAR IN LR_RYEAR AND POPER IN LR_POPER AND ( ( CPUDT = STARTDATE AND CPUTM >= STARTTIME ) OR CPUDT > STARTDATE ) AND ( ( CPUDT = ENDDATE AND CPUTM <= ENDTIME ) OR CPUDT < ENDDATE ). ENDIF. "First data package ?