timallen
Well Known Member
How do you determine which objects have been modified in an existing installation? I'm upgrading OneWorld B7332 to OneWorld Xe with the help of a much more experienced CNC. He has asked for a list of modified standard objects. I've tried running the following SQL to see how many objects have been modified by whom (I'm on Oracle 8.1.7):
select sijobn, count(*)
from objb733.f9861
where not (substr(siobnm, 2, 2) between '55' and '59')
group by sijobn
order by 2 desc
This produces a list like this:
SIJOBN COUNT(*)
---------- ----------
JDE 62596
R98700 1184
MAMUT 698
OWDEV 268
B7332ESOU 96
4605023 27
4116422 26
BAR-171 25
BAR-176 18
4605031 16
BAR-195 1
BAR-59 1
I reckon that SIJOBNs of JDE and R98700 I can disregard, since those are either unmodified or modified by an ESU. How about OWDEV?
Is there another way to do this that is more reliable? Thanks in advance
THIS CLIENT:
OneWorld B7332 (upgrading to Xe), E/S: RS6000, Oracle 8.1.7
select sijobn, count(*)
from objb733.f9861
where not (substr(siobnm, 2, 2) between '55' and '59')
group by sijobn
order by 2 desc
This produces a list like this:
SIJOBN COUNT(*)
---------- ----------
JDE 62596
R98700 1184
MAMUT 698
OWDEV 268
B7332ESOU 96
4605023 27
4116422 26
BAR-171 25
BAR-176 18
4605031 16
BAR-195 1
BAR-59 1
I reckon that SIJOBNs of JDE and R98700 I can disregard, since those are either unmodified or modified by an ESU. How about OWDEV?
Is there another way to do this that is more reliable? Thanks in advance
THIS CLIENT:
OneWorld B7332 (upgrading to Xe), E/S: RS6000, Oracle 8.1.7