|
View previous topic :: View next topic
|
| Author |
Message |
antonrino.b
New User
Joined: 10 Jan 2006
Posts: 76
Location: Germany
|
|
|
|
Hi,
I have a input file with the following layout
1-5 NAME X(5)
6-10 MARK1 9(5)
11-15 MARK2 9(5)
I need to extract only those records in which MARK1 > MARK2.
Is it possible using DFSORT?
Say,
My input file is
ANAME 00100 00101
BNAME 00200 00151
CNAME 00300 00121
DNAME 00400 00402
ENAME 00500 00101
My output file should look like
BNAME 00200 00151
CNAME 00300 00121
ENAME 00500 00101 |
|
| Back to top |
|
 |
CICS Guy
Senior Member
Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table
|
|
| 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:
| Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... input file
//SORTOUT DD DSN=... output file
//SYSIN DD *
OPTION COPY
INCLUDE COND=(6,5,ZD,GT,11,5,ZD)
/*
|
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:
Use [URL] BBCode for External Links |
|
| Back to top |
|
|
antonrino.b
New User
Joined: 10 Jan 2006
Posts: 76
Location: Germany
|
|
|
|
| Thanks a lot. |
|
| Back to top |
|
|
|
|
