| Author |
Message |
Pallavi Patil
New User
Joined: 24 Apr 2008
Posts: 1
Location: pune
|
|
|
|
hi,
I have two input files both having same primary key that is no duplicate records are present in both files and i want to get all the records from file1 whose primary key value matches with the same as that of input file 2.
example:
file 1
11111111 trtryykuy,iu
22222222 bttryrty5r6
file 2
11111111 dvrtrbtr
44444444 resrtrty
22222222 serwere
output file
1111111 dvrtrbtr
22222222 serwere |
|
| Back to top |
|
 |
References
|
 Posted: Fri Apr 25, 2008 6:53 pm Post subject: Re: comparing two files with key and writing in output file |
|
|
|
|
Frank Yaeger
DFSORT Moderator
Joined: 15 Feb 2005
Posts: 3798
Location: San Jose, CA
|
|
|
|
You can use this DFSORT/ICETOOL job to do what you asked for:
| Code: |
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//CON DD DSN=... input file1
// DD DSN=... input file2
//OUT DD DSN=... output file
//TOOLIN DD *
SELECT FROM(CON) TO(OUT) ON(1,8,CH) FIRSTDUP
/*
|
|
|
| Back to top |
|
|
|
|
