I want to compare two files with same LRECL (150) & file format is FB . The key filed (Jobname) is at different postiions in the both the files.
Could anyone help me on this?
FILE A:
Code:
109/17/2009 07:05:46 Unicenter CA-View Output Archival and Viewing (11.0)
SARBCT Batch Processing Utility - Sysout Archival Listing
0ID Jobname Jobid Gen Seq Arc Date Time Loc Lines Pages Blocks Xcode Tseq DRseq
-------------------------------- -------- -------- ----- ----- ---------- ----- ---- ---------- --------- --------- ------- ------ ----- -----
0$AGYX#NM Jobname1 JOB27854 4706 1 09/17/2009 06:24 DISK 3456 67 252
$AGYXCOM Jobname4 JOB27875 4706 1 09/17/2009 06:24 DISK 4567 67 345
$APO1RST Jobname3 JOB26592 4706 1 09/17/2009 06:54 DISK 5678 98 098
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
You really do need to provide all of the information for people to be able to help you.
What are the positions, lengths and formats of the key fields.
It looks as though you only require matched records from both files, but you have not stated this.
Also, it looks at though you only want records from file 1, but again you need to state this.
The lines above the actual data, are these for information only or do the exist in file1, and are they required in the output.
Which level of DFSORT are you using, as this can affect the solution quite dramatically. Please post the whole line with message code ICE201I from an output using DFSORT.
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
And
Quote:
Which level of DFSORT are you using, as this can affect the solution quite dramatically. Please post the whole line with message code ICE201I from an output using DFSORT.
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
meena chandran,
The following DFSORT/ICETOOL JCl will give you the desired results. I assumed that only the first 4 lines in your FILEA which has the duplicates are the header records
