View previous topic :: View next topic
|
Author |
Message |
a1javeed
New User
Joined: 10 Dec 2005 Posts: 20 Location: KUWAIT
|
|
|
|
Hi all
Kindly help me in this matter (!! i tried to find solution in the forum but i couldn't)
I have a file of FB 132 char as follwos
# CODE
1 4145
1 4146
1 4147
2 4145
2 4147
3 4147
4 4145
4 4146
I want to get the output file as follows using DFSORT/ICETOOL
3 4147
Thanks in Advance
Javeed |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
What rule(s) determine that (3 4147) is the only value to be written to the output? Are those the first bytes in the record? If your records are 132 why are only 6 bytes shown? You probably don't need to show all 132, but you need to properly describe what you have and what you want to do.
Also, it will help if you mention the recfm fo the files.
Depending on what your requirement actually is, you may be able to do what you want using INCLUDE or OMIT. There are many examples in the forum. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Javeed,
It really would help if you'd give more details as Dick mentioned.
But based on your Subject, description and example, I'll take a guess that you want to keep records which have only one occurrence of the value in position 1. If so, you can use a DFSORT/ICETOOL job like the following:
Code: |
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD *
1 4145
1 4146
1 4147
2 4145
2 4147
3 4147
4 4145
4 4146
/*
//OUT DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(IN) TO(OUT) ON(1,1,CH) NODUPS
/*
|
If that's not what you want, then you need to give the details of what you do want. |
|
Back to top |
|
|
a1javeed
New User
Joined: 10 Dec 2005 Posts: 20 Location: KUWAIT
|
|
|
|
Hi all
With the help of your replies i was able to get what i want with some modifications....
thank u very much again
Javeed |
|
Back to top |
|
|
|