109. EPMO Open Source Coordination Office Redaction File Detail Report

Produced by Araxis Merge on 11/9/2017 4:31:06 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.

109.1 Files compared

# Location File Last Modified
1 PPS-N_B397.zip\PPS-N_B397\PPS-N_B397\vaausppsapp82\sql PPSNEPL_EPL_NATIONAL_SETTINGS_APP82-RTC161179.sql Thu Nov 9 15:03:50 2017 UTC
2 PPS-N_B397.zip\PPS-N_B397\PPS-N_B397\vaausppsapp82\sql PPSNEPL_EPL_NATIONAL_SETTINGS_APP82-RTC161179.sql Thu Nov 9 21:55:12 2017 UTC

109.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 7 112
Changed 6 12
Inserted 0 0
Removed 0 0

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

109.4 Active regular expressions

No regular expressions were active.

109.5 Comparison detail

  1   /* Set dir ectory for  pending a nd approve d update f iles */
  2  
  3   UPDATE epl _national_ settings
  4   SET string _value = ' /home/ SERVER /pps-n/dev /app82/pen ding/'
  5   WHERE key_ name = 'ND F_OUTPUT_T ST_DIRECTO RY';
  6  
  7  
  8   UPDATE epl _national_ settings
  9   SET string _value = ' /home/ SERVER /pps-n/dev /app82/app roved/'
  10   WHERE key_ name = 'ND F_OUTPUT_P ROD_DIRECT ORY';
  11  
  12  
  13   UPDATE epl _national_ settings
  14   SET string _value = ' /u01/app/O racleHome/ user_proje cts/domain s/pps_dev2 /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/ SERVER /pps-n/dev /app82/rej ected/',
  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           'S ERVER',
  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           ' PW      ',
  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           ' PW      ',
  59           'D EVELOPER',
  60           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));
  61                              
  62   commit;