View previous topic :: View next topic
|
Author |
Message |
ajay_udl
New User
Joined: 10 Oct 2006 Posts: 29
|
|
|
|
Hi All,
Could you help me in providing a sort parameter to remove few records.
The record to be removed based on a value at position 67 with 2 byte length and its a Binary field (comp variable) having value 22.
thanks
ajay. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Here's a DFSORT job that will do what you asked for. I assumed your input file has RECFM=FB.
Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... input file (FB)
//SORTOUT DD DSN=... output file (FB)
//SYSIN DD *
OPTION COPY
OMIT COND=(67,2,BI,EQ,+22)
/*
|
|
|
Back to top |
|
|
ajay_udl
New User
Joined: 10 Oct 2006 Posts: 29
|
|
|
|
Thanks a lot Frank it worked.. |
|
Back to top |
|
|
|