Stat 6.3 - User Guide

Viewing and Merging Object Definitions

After the selecting the objects you want to compare, how you view the results of the comparison depends on the classification of the selected objects. See the following sections for information on viewing the comparison results of different object classes:

Comparing PeopleSoft Proprietary and Data Objects

You can view a detailed comparison of each data table that defines two PeopleSoft proprietary or data objects. For PeopleSoft proprietary objects, you can then use the Object Merge Wizard to combine the definitions into a new object, which can be added to an archive set and migrated to any environment you want to update. For more information, see the section, Merging PeopleSoft Proprietary Objects .

In the Object Compare Wizard, the definitions of the first and the second object you selected are displayed in the top and bottom sections of the window, respectively. The names of the data tables that comprise the two objects are displayed on the right. Select a table to view results of the comparison on a row by row basis. When you select a row in either the top or bottom section of the window, the wizard highlights its corresponding row in the other section of the window. If one object contains a row that does not exist in the definition of the second object (no row with same key values), when you select that row, no row is highlighted in the other object, which tells you that this row has no equivalent.

Both the names of the data tables, the rows that make up those tables, and the values contained in each row are color coded to indicate whether differences exist between the two objects. The following colors are used:

NOTE: When comparing when two PeopleSoft objects were last updated, the Object Compare Wizard disregards milliseconds, which is not recorded by all supported platforms

You can filter the comparison results with the following toolbar buttons:

If the data table you are comparing contains a Blob field that is textually formatted (as indicated by the value “BLOB” displayed in all caps), you can compare and merge the contents of the Blob field by clicking the Blob button. This opens the File Comparison tool, which displays both versions of the Blob field and identifies any differences that may exist. The File Comparison tool cannot compare blob information, however, if the source environment for one data table is Unicode and the other is non-Unicode; the source environments must be both either Unicode or non-Unicode. For more information, see Comparing File and Schema Objects .

NOTE: For PeopleSoft proprietary objects, you can compare and merge blob data fields from UDB/DB2 databases with objects from other UDB/DB2 databases or in Stat archive sets.

When you compare two version of a PeopleSoft Image object, the wizard displays an Image button that you can use to compare the two versions visually. If differences are reported by the wizard, select a row and click Image. This opens the Compare Images window which shows both versions of the image object.

You can also use the Object Compare Wizard to compare the PeopleCode scripts that those objects contain.

Comparing PeopleCode scripts is similar to comparing the text-based Blob field in other PeopleSoft objects. In both cases, the contents are compared textually in the File Comparison tool. When you compare PeopleCode scripts, however, Stat does the following:

Merging PeopleSoft Proprietary Objects

If you are comparing two versions of the same PeopleSoft proprietary object, you can merge the two versions to create a new object that is automatically archived by Stat. You can also compare and merge PeopleSoft proprietary objects that contain blob data from UDB/DB2 databases with other UDB/DB2 databases or with the Stat archives.

Comparing Objects in Oracle Applications

The Object Compare Wizard can show differences that exist between setup or developer object types for Oracle Applications. After you select the source locations and the two setup or developer objects you want to compare (or the two versions of the same object), click Next. The wizard processes the request and in the next window compares the properties of the two objects. The left side of the window displays in a merged tree view the structural classes and entities of the two objects. When you select an entity, the right side of the window shows any differences that may exist between the two objects.

NOTE: If you are comparing file (non-developer) type objects, Stat opens the File Comparison window. See the next section, Comparing File and Schema Objects for more information.

NOTE: If one object has a property with a null or empty value and the second object does not have this property, the Object Compare Wizard does not display the attribute property in the tree view or report this as a difference between the two objects.

The icons and flags displayed in the tree view indicate whether differences exist between the objects. Also, you can use the action buttons to control how information is displayed in the window. The table below describes the icons and action buttons featured in the window.

When you double-click on a property in the tree view, the wizard opens the Text Comparison window, which shows in detail any differences that may exist between the properties shared between the two objects. The Text Compare window functions and behaves the same way as the File Compare Window, except without any merge capabilities. For more information the File Compare window, see the section, Comparing File and Schema Objects .