rajesh_manas
New User
Joined: 30 Mar 2006 Posts: 11
|
|
|
|
Hi All,
I have some junk data in one particular field for some of the records in my Input file.
Using SORT , I want to eliminate all these Junk records.
Could anyone please let me know How we can exclude these Junk records from the Input file.
Note: The field which contains Junk value is Packed decimal type.
Thanks in advance,
Regards,
Rajesh |
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
If by "junk" values, you mean invalid PD values, you can use DFSORT's new NUM function to do that, but you'll need z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 (April, 2006) in order to use NUM. If you don't have the April, 2006 PTF, ask your System Programmer to install it (it's free). For complete details on all of the new DFSORT and ICETOOL functions available with the April, 2006 PTF, see:
Use [URL] BBCode for External Links
As an example, if you have a 5-byte PD value in positions 11-15 and you want to delete records with a "bad" value in that field, you can use these DFSORT statements:
Code: |
OPTION COPY
OMIT COND=(11,5,PD,NE,NUM)
|
|
|