Skip to Content
0
Nov 20, 2009 at 02:49 PM

Coding for Init w/o Data for Generic Extractor on GLPCA

20 Views

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 ?