133. EPMO Open Source Coordination Office Redaction File Detail Report

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

133.1 Files compared

# Location File Last Modified
1 PPS-N_B397.zip\PPS-N_B397\PPS-N_B397\vaausppsapp95\sql PPSNEPL_EPL_NATIONAL_SETTINGS_APP95-RTC161179.sql Thu Nov 9 15:01:00 2017 UTC
2 PPS-N_B397.zip\PPS-N_B397\PPS-N_B397\vaausppsapp95\sql PPSNEPL_EPL_NATIONAL_SETTINGS_APP95-RTC161179.sql Thu Nov 9 22:09:57 2017 UTC

133.2 Comparison summary

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

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

133.4 Active regular expressions

No regular expressions were active.

133.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/app95 /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/app95 /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_sqa5 /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/app95 /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           'R EDACTED',
  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;