Setting Compare Session Properties

To run a Compare session report, you must set the session properties. You can choose a range of rows to compare, set a limit to the number of difference rows to return, and determine how to match the columns for comparison.

To set Compare session properties:

1.         From the Compare Session page, select the session for which you want to set properties and click Properties.

The Compare Session Properties page appears.

2.         If desired, enter a range of rows to compare for each object.

3.         Enter a difference row limit. The default setting of "0" indicates no limit to the number of difference rows to return.

4.         In the Column Match By field, choose how to match the columns. If you select Manual, choose a match for each column in the source object from the columns in the target object.

Tip:     To switch the Source and Target objects, click Swap.

5.         Click Save.

DB2 Web Query saves the session properties.

Tip:     To remember these options as the default for all other sessions, click Save as Default.