View previous topic :: View next topic
|
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 |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 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 |
|
|
|