Determine modified objects?

timallen

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
 
How about looking at P98401, and QBE where Path Code = 'DV7333' (or whatever) and Mod Flag = 'C'. This will get you all the Objects that have been checked in, along with the OMW Project name in the "Modification Comment" field. This corresponds to a query:

SELECT T0.SIOBNM, T0.SIMKEY, T0.SIDM, T0.SIMSAR, T0.SIMRGMOD, T0.SIMRGOPT, T0.SIPATHCD, T0.SIMODCMT, T1.SIOBNM, T1.SIMD, T1.SISY, T1.SIFUNO FROM OBJ7333.F9861 T0,OBJ7333.F9860 T1 WHERE ( T0.SIPATHCD = 'DV7333' AND T0.SIMRGMOD = 'C' ) AND ( T1.SIOBNM=T0.SIOBNM ) ORDER BY T0.SIOBNM ASC

You may want to exclude the 55-59 objects and that should more or less give you your retrofit task.
 
Back
Top