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

106.1 Files compared

# Location File Last Modified
1 PPS-N_B397.zip\PPS-N_B397\PPS-N_B397\vaausppsapp60\sql PPSNEPL_EPL_NATIONAL_SETTINGS_APP60_STAGE-RTC161179.sql Thu Nov 9 15:02:52 2017 UTC
2 PPS-N_B397.zip\PPS-N_B397\PPS-N_B397\vaausppsapp60\sql PPSNEPL_EPL_NATIONAL_SETTINGS_APP60_STAGE-RTC161179.sql Thu Nov 9 21:53:33 2017 UTC

106.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 4 124
Changed 3 6
Inserted 0 0
Removed 0 0

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

106.4 Active regular expressions

No regular expressions were active.

106.5 Comparison detail

  1   /* Set dir ectory for  pending,  approved,  and reject ed update  files */
  2  
  3   /* APP60 S TAGING SER VER ONLY A PP60 */
  4  
  5  
  6   UPDATE epl _national_ settings
  7           SE T string_v alue = '/u 02/pps-n/s taging/pen ding/'
  8           WH ERE key_na me = 'NDF_ OUTPUT_TST _DIRECTORY ';
  9  
  10  
  11   UPDATE epl _national_ settings
  12           SE T string_v alue = '/u 02/pps-n/s taging/app roved/'
  13           WH ERE key_na me = 'NDF_ OUTPUT_PRO D_DIRECTOR Y';
  14  
  15  
  16   UPDATE epl _national_ settings
  17           SE T string_v alue = '/u 01/app/ora cle/user_p rojects/do mains/ppsn _stage/tmp /'
  18           WH ERE key_na me = 'NDF_ OUTPUT_FIL E_DIRECTOR Y';
  19  
  20  
  21   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  22          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  23   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  24           'N DF_OUTPUT_ TST_REJECT ED_DIRECTO RY',
  25           '/ u02/pps-n/ staging/re jected/',
  26           'D EVELOPER',
  27           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));
  28        
  29           
  30   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  31          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  32   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  33           'N DF_OUTPUT_ TST_REJECT ED_HOSTNAM E',
  34           'S ERVER',
  35           'D EVELOPER',
  36           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));
  37  
  38          
  39   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  40          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  41   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  42           'N DF_OUTPUT_ TST_REJECT ED_PASSWOR D',
  43           ' PW      ',
  44           'D EVELOPER',
  45           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));                     
  46  
  47           
  48   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  49          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  50   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  51           'N DF_OUTPUT_ TST_REJECT ED_PORT',
  52           '2 2',
  53           'D EVELOPER',
  54           (S ELECT CURR ENT_TIMEST AMP FROM D UAL)); 
  55    
  56           
  57   INSERT INT O EPL_NATI ONAL_SETTI NGS 
  58          (ID , KEY_NAME , STRING_V ALUE, CREA TED_BY, CR EATED_DTM)
  59   VALUES ((s elect max( ID) from E PL_NATIONA L_SETTINGS ) + 1,
  60           'N DF_OUTPUT_ TST_REJECT ED_USERNAM E',
  61           ' PW      ',
  62           'D EVELOPER',
  63           (S ELECT CURR ENT_TIMEST AMP FROM D UAL));                   
  64     
  65   commit;