Follow these steps:

  1. Open the Browse Dataset screen, Option 1 from the main menu.
  2. Identify the data set and member that contains your compare JCL.
  3. Press Enter. The compare JCL you have stored in the member displays.
  4. Type sub to submit your job for batch processing. A message confirming your submission displays.

How do I compare two flat files in mainframe?

  1. Sort file and file2.
  2. Read file1.
  3. Read file2 until key2 >= key1.
  4. check if key1=key2 perform required action.
  5. repeat step2 to 4 until end of both files.

What is the use of Icetool in JCL?

ICETOOL is a multi-purpose DFSORT utility used to perform a variety of operations on datasets. Input and output datasets can be defined using user defined DD names. The file operations are specified in the TOOLIN DD statement. Additional conditions can be specified in user defined ‘CTL’ DD statements.

How do you write a matching record in JCL?

JCL SORT to join two files and writes records from both files :

  1. Matched Records (Inner Join) –
  2. Matched Records and Non Matched Records from File1 –
  3. Non Matched from File1 –
  4. Matched Records and Non Matched from File2 –
  5. Non Matched from File2 –
  6. Matched Records and Non Matched Records from both files –

How do I compare two jobs in mainframe?

Select Tools > Options and select Comparison Tool to view comparison tool options. You can compare objects in the same project either by selecting both objects in the repository tree, or by selecting one object and then browsing for the other. You can compare two objects that are in different projects.

Which utility is used to compare the contents of sequential dataset and partitioned data?

IEBCOMPR
IEBCOMPR is a data set utility that is used to compare two sequential data sets, two partitioned data sets or two partisioned data sets (PDSEs) at the logical record level to verify a backup copy. Fixed, variable, or undefined records from blocked or unblocked data sets or members can also be compared.

What is catalog and Uncatalog in JCL?

Catalogs are used to retain information about datasets, such as volume(s), device type, etc. If you simply UNCATALOG a dataset, you can still use 3.4 but you must supply the volume information. Also, a dataset can be deleted but not uncataloged.

What is the difference between Dfsort and Syncsort?

DFSORT and SYNCSORT almost does the same thing-Sort. DFSORT is IBM’s product whereas SYNCSORT is a product sold by Syncsort.

How do I get unmatched records on Joinkeys?

1 Answer. It is a simple JOINKEYS: OPTION COPY JOINKEYS F1=INA,FIELDS=(4,80),SORTED,NOSEQCK JOINKEYS F2=INB,FIELDS=(4,80),SORTED,NOSEQCK JOIN UNPAIRED REFORMAT FIELDS=(F1:1,227,F2:1,227,?) The OPTION COPY is for the Main Task, the bit which runs after the joined file is produced.

How do I sort a file in JCL?

JCL – Basic Sort Tricks

  1. A file has 100 records. The first 10 records need to be written to output file.
  2. Input file has one or more records for same employee number. Write unique records to output.
  3. Overwrite input record content.

How can I compare two DataStage jobs?

Hold down the CTRL key and click the second object in the tree, then right-click and select ‘Compare selected’. Right-click and select Compare against, and then browse for the object, select it and click OK. DataStage takes some time to process the comparison, you should be patient.

What are different types of jobs in DataStage?

You can create 4 types of Jobs in DataStage infosphere.

  • Parallel Job.
  • Sequence Job.
  • Mainframe Job.
  • Server Job.

How to compare two files to get matching records?

The output file must have a particular column of the first file for those records whose column value matches with that of the column of the second file. Highligted fileds in the files are to be compared , and the output should have the vlaues from file 1 for the matching records. Thanks in Advance!

How can I extend a comparison between two files?

You can extend it in many ways. If the field to be compared is not in the same place in both files, you would reformat the records of one file to have the field in the same place as in the other file. In your example, you could reformat the first file field to position 5, or the second file field to position 1.

How to check for duplicates in input file2?

If there are duplicates within input file2, show that in the example. Give the starting position, length and format of the relevant fields. Give the RECFM and LRECL of the input files. Thanks Frank , I was about to suggest the same. Thanks Frank! I tried the icetool jcl which was available in the link .I t worked well.