Colonial Completed Tasks
Program: ADWPPAPZ
Assigned: 08/08/2008
Completed: 09/01/2008
Summary: The next change that we have is to the Performance process. I’ve done part of the work, but there is a piece still to be done. Due to a change that I am making, we will have duplicate rows that need to be posted. There is a program, ADWPPAPZ, already in test whose job it is to remove these duplicates because they net to zero (works with a sumsort in the prior step). Our goal is to no longer sum these records in the sort step prior to this program, but after it and keeping certain duplicate records. The records that we want to keep that would normally be summed and removed are ones where the hierarchy is different between the two records. Due to the age and size of the table, moving the hierarchy to the key is not an option. To accomplish this, it has been decided to change the process date for one of the two records to the week ending date on the datefile CLA.ADW.AWKLYDTE(0), copybook is CLA.PROD.COPYLIB(ADWYWKDT). Any records where this change is not necessary to protect the difference in hierarchies we still want to be able to sum and remove the totals that equal to zero. My JCL for this is in C9MAB.LIB.TEST(ADWAPERF).
Status: Moved into production 09/01/2008.
Program: ZDWPDBCN
Assigned: 09/12/2008
Summary: The program to modify is ZDWPDBCN from job ADWZDMNS. ZWVRDBCN is calculating its market dimensions from ZDWRSMDF using MKT_METH_ID = '02'. It should be using MKT_METH_ID = '04'. The field in ZWVRDBCN that need updating are:
- SUB_MKT_ID
- TARGET_MKT_ID
- PS_IND
- SUB_MKT_ID_DESC
This request is related to New Sales Dimension Tables (UL Deliverable III).
Status: Program modified, JCL ran against production & test, reviewed output
Production run output: TEST.ADW.DBCNLOAD(-1)
Test : TEST.ADW.DBCNLOAD(0)
The two files appear to differ only at DBCN-SUB-MKT-ID-DESC:
Ran job compared output, noticed following discrepancies:
EDIT A6608.ADW.PRDLOAD Columns 00073 00144
=COLS> --+----8----+----9----+----0----+----1----+----2----+----3----+----4----
****** ***************************** Top of Data ******************************
000001 CA1057223831985-05-07Small Commercial 1 NO SIC AVAILABLE
000002 UT0000000181984-05-15Small Commercial 1 NO SIC AVAILABLE
000003 MN0000000181984-08-07Small Commercial 1 NO SIC AVAILABLE
000004 MI0000000181985-06-20Medium Commercial 1 NO SIC AVAILABLE
000005 CO0000000181985-10-05Small Commercial 1 NO SIC AVAILABLE
000006 IA0000000181985-04-12Small Commercial 1 NO SIC AVAILABLE
000007 SD0000000181984-03-15Small Commercial 1 NO SIC AVAILABLE
Command ===> Scroll ===> CSR
. . . . . . . . . . . . . . . . . . . . . . . . . . .
File Edit Edit_Settings Menu Utilities Compilers Test Help
¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢
EDIT A6608.ADW.TSTLOAD Columns 00073 00144
****** ***************************** Top of Data ******************************
000001 CA1057223831985-05-07Small Comm 1-15 NO SIC AVAILABLE
000002 UT0000000181984-05-15Small Comm 1-15 NO SIC AVAILABLE
000003 MN0000000181984-08-07Small Comm 1-15 NO SIC AVAILABLE
000004 MI0000000181985-06-20Med Comm 100-249 NO SIC AVAILABLE
000005 CO0000000181985-10-05Small Comm 1-15 NO SIC AVAILABLE
Differs 115:14
Program ZDWPDBCN modified/tested. 9/12 request, modified data loaded into test DB2 table (9/17), waiting user approval.
Top of Page
URL :colonialcompletedtasks.html
Revised:10/14/2008
Layout, design & revisions David E. Huenger