IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

JCL for file comparison


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
cmsmoon

New User


Joined: 17 Jun 2010
Posts: 75
Location: Chennai

PostPosted: Thu Oct 16, 2014 1:09 pm
Reply with quote

Hi All,

I have two datasets which have different length.How to compare the dataset using sort cards

Example : my input file is

XMMD01.PROD.DATASET1 =>70 LENGTH
XMMD01.DEVL.DATASET1 =>120 LENGTH

COMPARSION SHOULD BE the file1 with file2 position from
1 to 30 => 30
40 to 70 => 30
110 to 120 =>10

can you please give me a idea or JCLS for this requirement.

we need to do the comparsion for 900 datasets like the above

Thanks in advance
Back to top
View user's profile Send private message
Ramsee

New User


Joined: 06 Jan 2011
Posts: 53
Location: Chennai

PostPosted: Thu Oct 16, 2014 1:26 pm
Reply with quote

Hi Saravanan,

Please find the URL for an Idea: ibmmainframeforum.com/viewtopic.php?f=61&t=5545
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Thu Oct 16, 2014 1:42 pm
Reply with quote

DO NOT post the same question in multiple forum areas !!

So what exactly are you going to compare bytes 110-120 against in a corresponding 70 byte record ?

What's wrong with the IBM compare utility that already exists ?
Obviously you can only compare the first 70 bytes of each record and that can so easily be achieved with the correct control statements.
Back to top
View user's profile Send private message
cmsmoon

New User


Joined: 17 Jun 2010
Posts: 75
Location: Chennai

PostPosted: Thu Oct 16, 2014 2:20 pm
Reply with quote

expat wrote:
DO NOT post the same question in multiple forum areas !!

So what exactly are you going to compare bytes 110-120 against in a corresponding 70 byte record ?

What's wrong with the IBM compare utility that already exists ?
Obviously you can only compare the first 70 bytes of each record and that can so easily be achieved with the correct control statements.



Hi expat,

The problem we have nearly 900 comparsion like this.So we compare manually it will have manualy work.
To avaoid this manual work
i just give the list of input dates
like
xmmd01.prod.set1 xmmd01.devl.set1 sortcard
xmmd01.prod.set2 xmmd01.devl.set2 sortcard
xmmd01.prod.set3 xmmd01.devl.set3 sortcard
....
....
....
xmmd01.prod.set900 xmmd01.devl.set900

So only file i give the above format and rexx code or JCLS will compare all the datsets and produce the results
this is what i am expecting
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Thu Oct 16, 2014 4:24 pm
Reply with quote

May give you some positive leads

www.ibmmainframes.com/viewtopic.php?t=56762


You can supply the file list to your REXX and use the program logic to build and action the compares for each file pair.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Fri Oct 17, 2014 12:51 am
Reply with quote

Quote:
JCLS will compare

JCLs (not JCLS) will NOT compare. JCL is a specific language that allows you to execute programs, application or utility, in batch. Please get the terminology correct.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top