Produced by Araxis Merge on 3/8/2018 10:11:32 AM Eastern 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.
# | Location | File | Last Modified |
---|---|---|---|
1 | PRE_PPS-N_v3.0.1.zip\PS_PPS_DataMgmt\src\main\resources\PPSN3.0\Data | PPSNEPL_EPL_NATIONAL_SETTINGS_APP60_STAGE-RTC161179.sql | Fri Jan 12 15:42:20 2018 UTC |
2 | PRE_PPS-N_v3.0.1.zip\PS_PPS_DataMgmt\src\main\resources\PPSN3.0\Data | PPSNEPL_EPL_NATIONAL_SETTINGS_APP60_STAGE-RTC161179.sql | Tue Mar 6 20:37:43 2018 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 2 | 142 |
Changed | 1 | 2 |
Inserted | 0 | 0 |
Removed | 0 | 0 |
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 |
No regular expressions were active.
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 01/app/pps /staging/p ending/' | |
8 | WH ERE key_na me = 'NDF_ OUTPUT_TST _DIRECTORY '; | |
9 | ||
10 | ||
11 | UPDATE epl _national_ settings | |
12 | SE T string_v alue = '/u 01/app/pps /staging/a pproved/' | |
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 | '/ u01/app/pp s/staging/ rejected/' , | |
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 | 'D NS URL', | |
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 | '& &sftp_pwd' , | |
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 | 'p resftp', | |
62 | 'D EVELOPER', | |
63 | (S ELECT CURR ENT_TIMEST AMP FROM D UAL)); | |
64 | ||
65 | commit; | |
66 | ||
67 | ||
68 | UPDATE PPS NEPL.EPL_N ATIONAL_SE TTINGS | |
69 | SE T INTEGER_ VALUE = 52 1 | |
70 | WH ERE KEY_NA ME = 'NATI ONAL_SITE_ NUMBER'; | |
71 | ||
72 | commit; |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.