Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Compare two files by composite key

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Shivendu

New User


Joined: 20 Feb 2009
Posts: 14
Location: Workstation

PostPosted: Mon Apr 06, 2009 5:08 pm    Post subject: Compare two files by composite key
Reply with quote

Need to compare data in two files FILE1 and FILE2. Data which is present ONLY in FILE2 should be written to a new file FILE3.

File lenght:3518 bytes
13 bytes starting at 455th position and one byte from 471 poition together make the key

Below code not working icon_sad.gif
Code:
COPY FROM(IN1) TO(T1) USING(CTL1)                       
COPY FROM(IN2) TO(T1) USING(CTL2)                       
SELECT FROM(T1) TO(OUT) ON(455,13,CH) ON(471,1,CH) NODUPS USING(CTL3)
/*                                                       
//CTL1CNTL DD *                                         
  INREC OVERLAY=(3519:C'1')                             
/*                                                       
//CTL2CNTL DD *                                         
  INREC OVERLAY=(3519:C'2')                             
/*                                                       
//CTL3CNTL DD *                                         
  OUTFIL FNAMES=OUT,INCLUDE=(3519,1,CH,EQ,C'2'),         
    BUILD=(1,3518)                                       
/*                                                       
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Mon Apr 06, 2009 5:31 pm    Post subject:
Reply with quote

Quote:
Below code not working

Please explain what is not working. What results do you expect and what are you getting.

Are your files FB or VB
Back to top
View user's profile Send private message
himanshu7

Active User


Joined: 28 Aug 2007
Posts: 131
Location: At Desk

PostPosted: Mon Apr 06, 2009 6:20 pm    Post subject:
Reply with quote

Didnt you get the solution from the below post?

http://ibmmainframes.com/viewtopic.php?t=39471&postdays=0&postorder=asc&start=15
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Apr 06, 2009 8:53 pm    Post subject:
Reply with quote

Hello,

Quote:
Below code not working
Do not post "it is not working".

When something is not working you need to post the abend or error message(s) including the message ids.
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Mon Apr 06, 2009 9:13 pm    Post subject:
Reply with quote

dick scherrer wrote:
Hello,

Quote:
Below code not working
Do not post "it is not working".

When something is not working you need to post the abend or error message(s) including the message ids.

...or wait until "psychic day" and then ask expat. icon_smile.gif
Back to top
View user's profile Send private message
Shivendu

New User


Joined: 20 Feb 2009
Posts: 14
Location: Workstation

PostPosted: Mon Apr 06, 2009 9:41 pm    Post subject: Reply to: Compare two files by composite key
Reply with quote

Thanks all for ur support. It is done!
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Apr 06, 2009 11:28 pm    Post subject: Reply to: Compare two files by composite key
Reply with quote

I suppose that is just dandy. . .

The problem was never posted and now the solution is not posted. . . icon_confused.gif

d
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Apr 07, 2009 12:21 pm    Post subject: Re: Reply to: Compare two files by composite key
Reply with quote

dick scherrer wrote:
I suppose that is just dandy. . .

The problem was never posted and now the solution is not posted. . . icon_confused.gif

d


Quote:
Didnt you get the solution from the below post?

http://ibmmainframes.com/viewtopic.php?t=39471&postdays=0&postorder=asc&start=15
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts member list compare jzhardy TSO/ISPF 6 Fri May 12, 2017 3:18 pm
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Dynamic split of files under groups sril.krishy DFSORT/ICETOOL 4 Mon Apr 17, 2017 1:09 pm
No new posts Compare two files and subtract values ameetmund DFSORT/ICETOOL 7 Fri Mar 31, 2017 3:35 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us