Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Compare Two files having different record lengths.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
dhanashreeakhade

New User


Joined: 11 Mar 2008
Posts: 8
Location: pune

PostPosted: Thu Jun 12, 2008 11:19 pm    Post subject: Compare Two files having different record lengths.
Reply with quote

Hi,

I have 2 files:
File1: Lrecl 1199
File2: Lrecl 1200

All fields of these 2 files are of same length and type except 1 field at position 874 (say COL874). This field has length of 4 char in file1 and lengh 5 char in file2.
So the fields coming after above mentioned field at position 874 in file1 , are shifted by 1 in file2.

Now all data in both files is same except for the COL874 field. I want to prepare a test case for the same. Can anyone please help me out how can I compare these 2 files and show that all data in files is same except for the column COL874?

Thanks,
Dhanashree.
Back to top
View user's profile Send private message

Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2353
Location: @my desk

PostPosted: Fri Jun 13, 2008 8:27 am    Post subject:
Reply with quote

Dhanashree,

With SUPERCE, you can specify the exact positions to compare.

Thanks,
Arun
Back to top
View user's profile Send private message
tangentray

New User


Joined: 30 Dec 2006
Posts: 20
Location: Kolkata, India

PostPosted: Fri Jun 13, 2008 11:30 am    Post subject:
Reply with quote

Round about way:

Use SYNCSORT with OUTREC to insert a space at the 874+4th position and create a new file of length 1200.

Now compare them with any method.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Comparing two sequential files Mohan Kothakota COBOL Programming 14 Mon Apr 16, 2018 6:35 pm
No new posts VSAM - Accessing beyond record size Benchwarmer JCL & VSAM 6 Wed Apr 11, 2018 9:20 pm
No new posts SORT 3 files,extract specific fields ... Kiransr DFSORT/ICETOOL 13 Fri Mar 23, 2018 10:54 am
No new posts Query to compare 2 values of 1 column... Poha Eater DB2 13 Fri Mar 09, 2018 10:45 am
No new posts How to build one file from two input ... daniele DFSORT/ICETOOL 5 Tue Feb 27, 2018 6:45 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us