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
 

 

DFSORT/ICETOOL

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

New User


Joined: 15 Feb 2006
Posts: 1

PostPosted: Thu Feb 04, 2010 2:40 am    Post subject: DFSORT/ICETOOL
Reply with quote

Please clarify below doubt in using sort utility

Input1
B052RRN.RASRSC.ASSOC11.EXT3

11aaaaaa111112
77gggggg777777
44dddddd444445
55eeeeee555555
22bbbbbb222223
66ffffff666666
88hhhhhh888888
33cccccc333333

Input2
B052RRN.RASRSC.ASSOC11.EXT2
11aaaaaa111111
77gggggg777777
44dddddd444444
55eeeeee555555
22bbbbbb222222
66ffffff666666
88hhhhhh888888
33cccccc333333

sort card used
JOINKEYS FILES=F1,FIELDS=(1,2,A,9,6,A)
JOINKEYS FILES=F2,FIELDS=(1,2,A,9,6,A)
JOIN UNPAIRED,F1,ONLY
REFORMAT FIELDS=(F1:9,6,F1:1,2)
SORT FIELDS=COPY


Output getting
11111211......
22222322......
44444544......

Expected output(what should be changed in sort card to get the below o/p)
Layout
1-6 bytes=fields mimatch from file
7-8 bytes=1st 2 bytes from file1
9-14bytes=fields from file2 having mismatch
11111211111111
22222322222222
44444544333333
Back to top
View user's profile Send private message

Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Thu Feb 04, 2010 3:16 am    Post subject: Reply to: DFSORT/ICETOOL
Reply with quote

anilaics,

How do you link the mismatching keys ? Is there some other which you can use to match?

Also what is the LRECL and recfm of the files involved?

What is the position and format of the keys

Post all the rules involved
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


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

PostPosted: Thu Feb 04, 2010 5:56 am    Post subject:
Reply with quote

Please use a meaningful Subject next time.
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 How to get the remainder and quotient... vnktrrd DFSORT/ICETOOL 2 Mon Oct 31, 2016 10:59 am
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts ICETOOL/SYNCSORT - SYSPRINT output nartcr DFSORT/ICETOOL 17 Wed Oct 05, 2016 10:46 pm
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm
No new posts Icetool or Joinkeys example to compar... ishant chauhan DFSORT/ICETOOL 21 Sat Aug 20, 2016 2:40 am


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