sambasivarao New User Joined: 10 Jul 2006 Posts: 47 Location: Bangalore
Iam getting the Sequential file.
In that file i found that some of the Duplicate policies are there.
I want to eliminate those duplicate policies.
Could you please let me know how to eliminate duplicates using DFSORT.
Thanks in advance.
William Thompson Global Moderator Joined: 18 Nov 2006 Posts: 3158 Location: Tucson AZ
dick scherrer Site Director Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
This question would be better asked in the DFSORT forum rather than this DB2 forum. . .
Also, as W.T. pointed out, there are multiple solutions to this question in the DFSORT forum.
priyesh.agrawal Senior Member Joined: 28 Mar 2005 Posts: 1452 Location: Chicago, IL
Still if you dont find answer to your question, you need to give RECFM and LRECL of your sequential file.
Also the starting position of the "policies" with the length (on which you need to check duplicates).
Frank Yaeger DFSORT Moderator Joined: 15 Feb 2005 Posts: 7130 Location: San Jose, CA
If you just want one record with each policy value as output, you can use a DFSORT/ICETOOL job like this:
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=... input file
//OUT DD DSN=... output file
//TOOLIN DD *
SELECT FROM(IN) TO(OUT) ON(p,m,f) FIRST
where p,m,f is the starting position, length and format of the policy field.
If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:
All times are GMT + 6 Hours