PRCHLO ;WOIFO/RLL-EXTRACT ROUTINE CLO REPORT SERVER ;12/30/10 14:34
Source file <PRCHLO.m>
action | A | extended action | Ea | event driver | Ed | subscriber | Su | protocol | O | limited protocol | LP | run routine | RR | broker | B | edit | E | server | Se | P | screenman | SM | inquire | I |
Name | Comments | DBIA/ICR reference |
---|---|---|
INIT | ; Initialize environment
|
|
CALC | ;test entry point, set %I to FM date
|
|
FYRNOW | ; Changes added 07/31/06 RLL for new extract date range.
; CLOBGN will always be the beginning of the Fiscal Year (Oct 1st) ; This will be the start range for each extract. ; This routine is called through the option : ; [PRCHLO CLO PROCUREMENT] which is queued to run in TaskMan ; This option should be queued to run 2 hours AFTER ; [PRCHLO GIP OPTION] and should be run on the same day ; (after midnight) as the [PRCHLO GIP OPTION]. As an example: ; 1. Que [PRCHLO GIP OPTION] to run 12:00am the 1st of the month ; 2. Que [PRCHLO CLO PROCUREMENT] to run 1:00am the 1st of the month |
|
STCLOBGN | ; Set CLOBGN to Beginning of Fiscal Year (Oct. 1)
; |
|
DEBUGFY | ; Debug Fiscal Year logic by uncommenting code below 7/31/06 RLL
|
|
GPARM | ; Get parameters for monthly extract
|
|
EXTR | ; Extract the data, create files
|
|
GKEY | ; get key for all tables
|
>> | Not killed explicitly |
* | Changed |
! | Killed |
~ | Newed |
Name | Field # of Occurrence |
---|---|
% | INIT+5~, INIT+6*, CALC+4, CALC+6, STCLOBGN+5, STCLOBGN+9 |
CKTP | DEBUGFY+4~, DEBUGFY+5*, DEBUGFY+6 |
CLO1 | CALC+2~, CALC+4*, CALC+7, CALC+15, CALC+16, CALC+21*, CALC+22, CALC+23, CALC+26, CALC+28 , GPARM+11*, GPARM+12*, GPARM+13, GPARM+14, GKEY+3 |
CLO1A | CALC+2~, CALC+26*, CALC+27 |
CLO2 | CALC+2~, CALC+6*, CALC+9, CALC+10, CALC+11, CALC+13, CALC+20, CALC+25, GPARM+11*, GPARM+13* , GKEY+2 |
CLO2B | CALC+2~, CALC+11*, CALC+12*, CALC+15 |
CLO2E | CALC+2~, CALC+13*, CALC+14*, CALC+16 |
CLO3 | CALC+2~, GPARM+11* |
CLOBGN | CALC+2~, CALC+15*, CALC+22*, CALC+27*, STCLOBGN+4*, STCLOBGN+8*, GPARM+11 |
CLOEND | CALC+2~, CALC+16*, CALC+23*, CALC+28*, STCLOBGN+5*, STCLOBGN+9*, GPARM+14 |
>> CLRSERR | DEBUGFY+7* |
FMDT1 | GPARM+4~, GPARM+5*, GPARM+6 |
MNTHYR | GPARM+4~, GPARM+7* |
MTHRUN | CALC+3~, CALC+9*, STCLOBGN+2, STCLOBGN+7 |
MYRVAL | GPARM+4~, GPARM+6*, GPARM+7 |
POCRDAT | GKEY+1~, GKEY+3* |
POID | GKEY+1~, GKEY+2* |
PYRRUN | CALC+3~, CALC+8*, STCLOBGN+8 |
YRRUN | CALC+3~, CALC+7*, CALC+8, STCLOBGN+4 |