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

113.1 Files compared

# Location File Last Modified
1 PPS-N_B397.zip\PPS-N_B397\PPS-N_B397\vaausppsapp84\sql PPSNEPL_EPL_NATIONAL_SETTINGS_APP84-RTC161179.sql Thu Nov 9 15:03:00 2017 UTC
2 PPS-N_B397.zip\PPS-N_B397\PPS-N_B397\vaausppsapp84\sql PPSNEPL_EPL_NATIONAL_SETTINGS_APP84-RTC161179.sql Thu Nov 9 21:58:34 2017 UTC

113.2 Comparison summary

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

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

113.4 Active regular expressions

No regular expressions were active.

113.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/tes tsqa/app84 /pending/'
  5   WHERE key_ name = 'ND F_OUTPUT_T ST_DIRECTO RY';
  6  
  7   UPDATE epl _national_ settings
  8   SET string _value = ' /home/ SERVER /pps-n/tes tsqa/app84 /approved/ '
  9   WHERE key_ name = 'ND F_OUTPUT_P ROD_DIRECT ORY';
  10  
  11   UPDATE epl _national_ settings
  12   SET string _value = ' /u01/app/O racleHome/ user_proje cts/domain s/pps_dev4 /tmp/'
  13   WHERE key_ name = 'ND F_OUTPUT_F ILE_DIRECT ORY';
  14  
  15  
  16   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  17          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  18   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  19           'N DF_OUTPUT_ TST_REJECT ED_DIRECTO RY',
  20             '/home/ SERVER /pps-n/tes tsqa/app84 /rejected/ ',
  21           'D EVELOPER',
  22           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));
  23  
  24           
  25   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  26          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  27   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  28           'N DF_OUTPUT_ TST_REJECT ED_HOSTNAM E',
  29           'S ERVER',
  30           'D EVELOPER',
  31           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));
  32  
  33          
  34   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  35          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  36   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  37           'N DF_OUTPUT_ TST_REJECT ED_PASSWOR D',
  38           ' PW      ',
  39           'D EVELOPER',
  40           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));                     
  41  
  42           
  43   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  44          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  45   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  46           'N DF_OUTPUT_ TST_REJECT ED_PORT',
  47           '2 2',
  48           'D EVELOPER',
  49           (S ELECT CURR ENT_TIMEST AMP FROM D UAL)); 
  50    
  51           
  52   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  53          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  54   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  55           'N DF_OUTPUT_ TST_REJECT ED_USERNAM E',
  56           ' PW      ',
  57           'D EVELOPER',
  58           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));                   
  59  
  60   commit;