13. EPMO Open Source Coordination Office Redaction File Detail Report

Produced by Araxis Merge on 11/9/2017 4:31:02 PM Central Standard Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.

13.1 Files compared

# Location File Last Modified
1 PPS-N_B397.zip\PPS-N_B397\PPS-N_B397\PS_PPS_DataMgmt\src\main\resources\PPSN3.0\Data PPSNEPL_EPL_NATIONAL_SETTINGS_APP21_PROD-RTC161179.sql Thu Nov 9 15:02:42 2017 UTC
2 PPS-N_B397.zip\PPS-N_B397\PPS-N_B397\PS_PPS_DataMgmt\src\main\resources\PPSN3.0\Data PPSNEPL_EPL_NATIONAL_SETTINGS_APP21_PROD-RTC161179.sql Thu Nov 9 20:33:57 2017 UTC

13.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 4 140
Changed 3 6
Inserted 0 0
Removed 0 0

13.3 Comparison options

Whitespace
Character case Differences in character case are significant
Line endings Differences in line endings (CR and LF characters) are ignored
CR/LF characters Not shown in the comparison detail

13.4 Active regular expressions

No regular expressions were active.

13.5 Comparison detail

  1   /* Set dir ectory for  pending,  approved,  and reject ed update  files */
  2  
  3   /* APP21 P REPROD SER VER ONLY A PP21 */
  4  
  5    
  6   UPDATE PPS NEPL.EPL_N ATIONAL_SE TTINGS
  7           SE T string_v alue = '/a pp/pps/pro duction/pe nding/'
  8           WH ERE key_na me = 'NDF_ OUTPUT_TST _DIRECTORY ';
  9  
  10  
  11   UPDATE PPS NEPL.EPL_N ATIONAL_SE TTINGS
  12           SE T string_v alue = '/a pp/pps/pro duction/ap proved/'
  13           WH ERE key_na me = 'NDF_ OUTPUT_PRO D_DIRECTOR Y';
  14  
  15  
  16   UPDATE PPS NEPL.EPL_N ATIONAL_SE TTINGS
  17           SE T string_v alue = '/u 01/app/ora cle/user_p rojects/do mains/ppsn _prod/tmp/ '
  18           WH ERE key_na me = 'NDF_ OUTPUT_FIL E_DIRECTOR Y';
  19  
  20  
  21   INSERT INT O PPSNEPL. EPL_NATION AL_SETTING
  22          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  23   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  24           'N DF_OUTPUT_ TST_REJECT ED_DIRECTO RY',
  25           '/ app/pps/pr oduction/r ejected/',
  26           'D EVELOPER',
  27           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));
  28        
  29           
  30   INSERT INT O PPSNEPL. EPL_NATION AL_SETTING
  31          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  32   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  33           'N DF_OUTPUT_ TST_REJECT ED_HOSTNAM E',
  34           'S ERVER.DOMA IN',
  35           'D EVELOPER',
  36           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));
  37  
  38          
  39   INSERT INT O PPSNEPL. EPL_NATION AL_SETTING
  40          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  41   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  42           'N DF_OUTPUT_ TST_REJECT ED_PASSWOR D',
  43           ' PW         ',
  44           'D EVELOPER',
  45           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));                     
  46  
  47           
  48   INSERT INT O PPSNEPL. EPL_NATION AL_SETTING
  49          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  50   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  51           'N DF_OUTPUT_ TST_REJECT ED_PORT',
  52           '2 2',
  53           'D EVELOPER',
  54           (S ELECT CURR ENT_TIMEST AMP FROM D UAL)); 
  55    
  56           
  57   INSERT INT O PPSNEPL. EPL_NATION AL_SETTING
  58          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  59   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  60           'N DF_OUTPUT_ TST_REJECT ED_USERNAM E',
  61           ' PW      ',
  62           'D EVELOPER',
  63           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));                   
  64     
  65   commit;
  66  
  67  
  68   UPDATE PPS NEPL.EPL_N ATIONAL_SE TTINGS 
  69           SE T INTEGER_ VALUE = 52
  70           WH ERE KEY_NA ME = 'NATI ONAL_SITE_ NUMBER';  
  71  
  72   commit;
  73