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
 
joining on record

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

New User


Joined: 17 Apr 2009
Posts: 70
Location: India

PostPosted: Sun Dec 20, 2009 8:53 pm    Post subject: joining on record
Reply with quote

Hi All

I have a requirement like this, Can you please help

File 1 FB 80
Code:
1234 10000   1
1234 20000   4
1235 25000   10
1235 30000   10
1236 15000   5
1237 15000   10
1285 (spaces)20


File 2 FB 80
Code:
1234 10000   6
1235 25000   10
1235 35000   10
1236 15000   5


Keys here are first four bytes(1 to 4) and 18bytes (6 to 23), and need a out put some thing like this

Code:
1234 10000   1    6   
1234 20000   4    0
1235 25000   10  10
1235 30000   10  10
1236 15000   5    5
1237 15000   10   0
1285 (spaces)20   0


which means file is having a record 1234 10000 where its count in this file is 1 and file2 having a record 1234 10000 where its count is 6 so i need oput 1234 10000 1 6 (1 is from file1 and 6 is from file2 for same record)

there wont be dublicates and both the files will be in sorted order
There could be record which is there in file1 but not in file 2
Back to top
View user's profile Send private message

Lijo

New User


Joined: 24 Aug 2008
Posts: 41
Location: Cochin

PostPosted: Mon Dec 21, 2009 5:11 pm    Post subject: Reply to: joining on record
Reply with quote

I tried understanding your output data. But this one didn't make sense to me. Is this correct?

Quote:
1235 30000 10 10


should this be 1235 30000 10 0???

Also,
Quote:
Keys here are first four bytes(1 to 4) and 18bytes (6 to 23),

18bytes for secondary Keys, But in your example I couldn't recognize this 18 bytes. Are you looking for a match on 6 to 6 bytes?
Back to top
View user's profile Send private message
Garry Carroll

Active Member


Joined: 08 May 2006
Posts: 995
Location: Dublin, Ireland / Edinburgh, Scotland

PostPosted: Mon Dec 21, 2009 5:46 pm    Post subject:
Reply with quote

Also, do you mean to drop the 3rd record from File2 - 1235 35000 10 ?

Garry.
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 Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts Repeat part of record multiple times Learncoholic DFSORT/ICETOOL 4 Tue Aug 29, 2017 11:33 am
No new posts Read two inputs and write into output... murali.andaluri DFSORT/ICETOOL 6 Wed Jul 26, 2017 7:35 pm
No new posts Need to write record of PS File in ex... Chandan1993 JCL & VSAM 1 Wed Jun 07, 2017 1:35 am
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am

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