Page 1 of 1

matching logic

PostPosted: Thu Sep 03, 2009 8:21 am
by mainframe1
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

Re: matching logic

PostPosted: Thu Sep 03, 2009 8:59 pm
by Frank Yaeger
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?

Re: matching logic

PostPosted: Fri Sep 04, 2009 9:58 am
by mainframe1
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

Re: matching logic

PostPosted: Sat Sep 05, 2009 5:13 am
by Frank Yaeger
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.