Browse Prior Art Database

Control Statement driven z/OS utility for compairing unordered lists in dissimilar columns between sequential files or PDS members

IP.com Disclosure Number: IPCOM000021698D
Original Publication Date: 2004-Feb-03
Included in the Prior Art Database: 2004-Feb-03
Document File: 3 page(s) / 43K

Publishing Venue

IBM

Abstract

A generalized data set comparison is performed which determines whether entries in one list are present in another list. Control statements are utilized by which the user can define the algorithms used to match the lists, and to describe follow-up actions which can be taken. Examples of the use of such a dataset comparison include the following: a) Confirmation that PDS members in one dataset are found in another (where the index of the PDS is captured as a list) b) Confirmation that PDS members are represented in list of data found in a sequential file c) Creation of lists of matching elements d) Creation of lists of non-matching elements e) Creation of auxiliary files containing data related to the matches or non-matches between the lists

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 49% of the total text.

Page 1 of 3

Control Statement driven z /OS utility for compairing unordered lists in dissimilar columns between sequential files or PDS members

Background

The ability to compare two lists to determine whether all of the entries on one are included in the other is a commonly needed function. Tools such as SUPERC are included with ISPF on z/OS systems, and are very good at determining whether two files match, and at identifying the line at which a mismatch is determined. However, while some tools may have some function exceeding the following , the existing tools are tailored to be most useful on datasets with the following characteristics: a) Lists where the data to be compared begins in the same

relative column in the files to be compared

b) Data layouts where the entire records are to be compared

c) Lists which are of comparable formats

Tools such as SUPERC are very good at instances where the two lists being compared are similarly formatted and will find the differences between the two lists. However, if the two lists do not line up in the same column, SUPERC is not as good at recognizing the similarities.

The current invention is a generalized data set comparison which determines whether entries in one list are present in another list. The invention utilizes control statements by which the user can define the algorithms used to match the lists, and to describe follow-up actions which can be taken.

Examples of the use of such a dataset comparison include the following:

a) Confirmation that PDS members in one dataset are found in another

(where the index of the PDS is captured as a list)

b) Confirmation that PDS members are represented in list of data

found in a sequential file

c) Creation of lists of matching elements

d) Creation of lists of non-matching elements

e) Creation of auxiliary files containing data related to the

matches or non-matches between the lists

Summary of Invention:

The current invention is a generalized list comparison which addresses some limitations of other data comparison tools. The following functions are supported:

- Specification of length of an element in the list

- Specification of the offset of an element in the list

where the offset can be from the beginning or from the end of a record

- Different offsets are allowed for either file

- Identify those elements which match

1

Page 2 of 3

- Identify those elements which are contained in one file, but not the other - Retain or discard those records containing matching elements - Retain or discard those records which do not contain matching elements - Create new data records which merge data from the matching records

- Returns a completion code of '0' when the datasets match comparably, or

nonzero when differences are found.

The invention utilizes control statements by which the user can define the algorithms for what constitutes an element to be matched. For the further discussion, the files will be referred to as "File A" and "File B" respectively. Among the param...