matching logic



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

matching logic

Postby mainframe1 » Thu Sep 03, 2009 8:21 am

hi,
i have 2 file
file1

1111
1111
3333
2222
2222
4444
4444

file 2

2222
2222
4444
4444
5555
6666

i ned t the o/p to be
2222
2222
4444
4444

pls let me know how to run thr sort card using icetool/iceman

regards
mainframe1
 
Posts: 35
Joined: Wed Oct 08, 2008 11:39 am
Has thanked: 0 time
Been thanked: 0 time

Re: matching logic

 

Re: matching logic

Postby Frank Yaeger » Thu Sep 03, 2009 8:59 pm

Is this a puzzle? Are we supposed to "devine" what the "rules" are? The output seems to have matching keys with two records in file1 and two records in file2 (2222, 4444). That's not much to go on for establishing the complete set of rules. What about matching keys with one record in file1 and one record in file2, with two records in file1 and one record in file2, etc.

YOU need to show an example of input and output with all the possibilities of interest. YOU need to explain the "rules" you want to use to get from input to output. Also, give the RECFM and LRECL of the input file. And which SORT product are you using?
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

Re: matching logic

Postby mainframe1 » Fri Sep 04, 2009 9:58 am

sorry frank,

the lrecl is 5 and recfm is fixed. i need to get the matching records in file and file2.The keys are the inital 5 numbers only

thanks
mainframe1
 
Posts: 35
Joined: Wed Oct 08, 2008 11:39 am
Has thanked: 0 time
Been thanked: 0 time

Re: matching logic

Postby Frank Yaeger » Sat Sep 05, 2009 5:13 am

You didn't actually answer my questions or show the example I asked for so I still don't know the "rules" you want to use or which sort product you are using.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post