18. EPMO Open Source Coordination Office Redaction File Detail Report

Produced by Araxis Merge on 3/8/2018 10:11:32 AM Eastern 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.

18.1 Files compared

# Location File Last Modified
1 PRE_PPS-N_v3.0.1.zip\PS_PPS_DataMgmt\src\main\resources\PPSN3.0\Data PPSNEPL_EPL_NATIONAL_SETTINGS_APP40_PREPROD-RTC161179.sql Fri Jan 12 15:42:20 2018 UTC
2 PRE_PPS-N_v3.0.1.zip\PS_PPS_DataMgmt\src\main\resources\PPSN3.0\Data PPSNEPL_EPL_NATIONAL_SETTINGS_APP40_PREPROD-RTC161179.sql Tue Mar 6 20:37:34 2018 UTC

18.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 2 142
Changed 1 2
Inserted 0 0
Removed 0 0

18.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

18.4 Active regular expressions

No regular expressions were active.

18.5 Comparison detail

  1   /* Set dir ectory for  pending,  approved,  and reject ed update  files */
  2  
  3   /* APP40 P REPROD SER VER ONLY A PP40 */
  4  
  5  
  6   UPDATE epl _national_ settings
  7           SE T string_v alue = '/u 01/app/pps /preprod/p ending/'
  8           WH ERE key_na me = 'NDF_ OUTPUT_TST _DIRECTORY ';
  9  
  10  
  11   UPDATE epl _national_ settings
  12           SE T string_v alue = '/u 01/app/pps /preprod/a pproved/'
  13           WH ERE key_na me = 'NDF_ OUTPUT_PRO D_DIRECTOR Y';
  14  
  15  
  16   UPDATE epl _national_ settings
  17           SE T string_v alue = '/u 01/app/ora cle/user_p rojects/do mains/ppsn _preprod/t mp/'
  18           WH ERE key_na me = 'NDF_ OUTPUT_FIL E_DIRECTOR Y';
  19  
  20  
  21   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  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           '/ u01/app/pp s/preprod/ rejected/' ,
  26           'D EVELOPER',
  27           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));
  28        
  29           
  30   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  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           'D NS  URL',
  35           'D EVELOPER',
  36           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));
  37  
  38          
  39   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  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           '& &sftp_pwd' ,
  44           'D EVELOPER',
  45           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));                     
  46  
  47           
  48   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  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 EPL_NATI ONAL_SETTI NGS 
  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           'p resftp',
  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;