pankajupadhyay Warnings : 1 New User
Joined: 04 May 2007 Posts: 13 Location: pune
|
|
|
|
hello,
i have sort-in file that contain many duplicate,i need to sorted output in sort-out file without duplicates and all the duplicates in another file( in aaaaa.bbbb.ccc(mamber1) how will i achive this by dfsort, and how to write the file name in jcl . |
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
It's not clear exactly what you want to do, but I'm guessing you can accomplish it using the SELECT statement of DFSORT's ICETOOL. Something like this:
Code: |
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=... input file
//OUT1 DD DSN=... output file1
//OUT2 DD DSN=... output file2
//TOOLIN DD *
SELECT FROM(IN) TO(OUT1) ON(p,m,f) FIRST DISCARD(OUT2)
|
For complete details on SELECT, see:
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/6.11?DT=20060615185603
If you want more specific help, provide more information as follows:
Show an example of the records in your input file (relevant fields) and what you expect for output. What is the RECFM and LRECL of your input file? What is the starting position, length and format of the key you want to check for duplicates on? |
|