10. EPMO Open Source Coordination Office Redaction File Detail Report

Produced by Araxis Merge on 7/9/2017 11:00:46 PM Eastern Daylight 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.

10.1 Files compared

# Location File Last Modified
1 PPS_N_3.0_Iter2_Build_360.zip\Unredacted\PS_PPS_DataMgmt\src\main\resources\PPSN3.0\Data PPSNEPL_EPL_NATIONAL_SETTINGS_APP60_STAGE-RTC161179.sql Fri Jun 30 19:06:08 2017 UTC
2 PPS_N_3.0_Iter2_Build_360.zip\Unredacted\PS_PPS_DataMgmt\src\main\resources\PPSN3.0\Data PPSNEPL_EPL_NATIONAL_SETTINGS_APP60_STAGE-RTC161179.sql Wed Jul 5 13:01:07 2017 UTC

10.2 Comparison summary

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

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

10.4 Active regular expressions

No regular expressions were active.

10.5 Comparison detail

  1   /* Set dir ectory for  pending a nd approve d update f iles */
  2   /* STAGING  SERVER ON LY APP60 * /
  3  
  4   UPDATE epl _national_ settings
  5   SET string _value = ' /home/pres ftp/pps-n/ stage/app6 0/pending/ '
  6   WHERE key_ name = 'ND F_OUTPUT_T ST_DIRECTO RY';
  7  
  8  
  9   UPDATE epl _national_ settings
  10   SET string _value = ' /home/pres ftp/pps-n/ stage/app6 0/approved /'
  11   WHERE key_ name = 'ND F_OUTPUT_P ROD_DIRECT ORY';
  12  
  13   UPDATE epl _national_ settings
  14   SET string _value = ' /u01/app/O racleHome/ user_proje cts/domain s/pps_stag e/tmp/'
  15   WHERE key_ name = 'ND F_OUTPUT_F ILE_DIRECT ORY';
  16  
  17  
  18   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  19          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  20   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  21           'N DF_OUTPUT_ TST_REJECT ED_DIRECTO RY',
  22           '/ home/presf tp/pps-n/s tage/app60 /rejected/ ',
  23           'D EVELOPER',
  24           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));
  25        
  26           
  27   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  28          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  29   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  30           'N DF_OUTPUT_ TST_REJECT ED_HOSTNAM E',
  31           'D NS.DNS   ' ,
  32           'D EVELOPER',
  33           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));
  34  
  35          
  36   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  37          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  38   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  39           'N DF_OUTPUT_ TST_REJECT ED_PASSWOR D',
  40           'I m@g!N3',
  41           'D EVELOPER',
  42           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));                     
  43  
  44           
  45   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  46          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  47   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  48           'N DF_OUTPUT_ TST_REJECT ED_PORT',
  49           '2 2',
  50           'D EVELOPER',
  51           (S ELECT CURR ENT_TIMEST AMP FROM D UAL)); 
  52    
  53           
  54   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  55          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  56   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  57           'N DF_OUTPUT_ TST_REJECT ED_USERNAM E',
  58           'p resftp',
  59           'D EVELOPER',
  60           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));                   
  61     
  62   commit;