Bathrinarayanan
New User
Joined: 15 Nov 2007
Posts: 4
Location: chennai
|
|
|
|
Hi,
I want to compare Year in the date field of a file with Current Year and INCLUDE such records into my output file. File attributes are FB, LRECL=80.
Sample Input file
| Code: |
Ref-No Name Date-field
4124323 BATHRINARAYANAN 20100112
3134532 BATHRI 20090112
|
My preferred output is
| Code: |
4124323 BATHRINARAYANAN 20100112
|
Since it is only matched with the current year 2010.
Please suggest a way to achieve it..
Thanks in Advance.. |
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
You can use a DFSORT job like the following to do what you asked for. I assumed your year starts in position 26.
| Code: |
//S1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SYMNAMES DD *
CURYR,S'&YR4'
/*
//SORTIN DD DSN=... input file
//SORTOUT DD DSN=... output file
//SYSIN DD *
OPTION COPY
INCLUDE COND=(26,4,CH,EQ,CURYR)
/*
|
|
|
