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

117.1 Files compared

# Location File Last Modified
1 PPS-N_B397.zip\PPS-N_B397\PPS-N_B397\vaausppsapp85\sql PPSNEPL_EPL_NATIONAL_SETTINGS_APP85-RTC161179.sql Thu Nov 9 15:02:54 2017 UTC
2 PPS-N_B397.zip\PPS-N_B397\PPS-N_B397\vaausppsapp85\sql PPSNEPL_EPL_NATIONAL_SETTINGS_APP85-RTC161179.sql Thu Nov 9 22:01:16 2017 UTC

117.2 Comparison summary

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

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

117.4 Active regular expressions

No regular expressions were active.

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