|
View previous topic :: View next topic
|
| Author |
Message |
Purnendu.it
New User
Joined: 11 May 2007
Posts: 57
Location: chennai
|
|
|
|
Hi all,
Requirement is like that.i need to compare the two file which have
same record length and structure.And need to write the unmatched record
in a output file in a job itself. |
|
| Back to top |
|
 |
Purnendu.it
New User
Joined: 11 May 2007
Posts: 57
Location: chennai
|
|
|
|
sorry for posting here it should have been posted in sort..
to furthere add i need to use any sort card |
|
| Back to top |
|
|
Purnendu.it
New User
Joined: 11 May 2007
Posts: 57
Location: chennai
|
|
|
|
Requirement is like that.i need to compare the two file which have
same record length and structure.And need to write the unmatched record
in a output file in a job itself. |
|
| Back to top |
|
|
vasanthkumarhb
Active User
Joined: 06 Sep 2007
Posts: 275
Location: Bang,iflex
|
|
| Back to top |
|
|
Naidu540
New User
Joined: 17 Apr 2008
Posts: 1
Location: Bangalore
|
|
|
|
//SORTTOOL EXEC PGM=SORT
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SORTJNF1 DD DSN=FIRST.FILE,DISP=SHR
//SORTJNF2 DD DSN=SECOND.FILE,DISP=SHR
//SORTOUT DD DSN=THIRD.FILE,DISP=SHR
//SYSIN DD *
SORT FIELDS=COPY
JOINKEYS FILES=F1,FIELDS=(1,10,A)
JOINKEYS FILES=F2,FIELDS=(1,10,A)
JOIN UNPAIRED F1,ONLY(IF YOU WANT UNMATCHED RECORDS FROM F1 FILE )
IF U WANT RECORDS FROM BOTH FILES FI,F2 YOU CAN USE JOIN UNPAIRED F1,F2,ONLY)
AT FIELDS = (1,10, A) YOU NEED TO GIVE THE LENGTHS ACCORDING TO YOUR REQUIREMNT. |
|
| Back to top |
|
|
Aaru
Senior Member
Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India
|
|
|
|
Pur,
| Quote: |
And need to write the unmatched record
in a output file in a job itself. |
This has been discussed many times. Search the DFSORT/ICETOOL forum with the Keyword as "SELECT" for examples. |
|
| Back to top |
|
|
|
|
