MVSFORUMS.com

[yadav2005]

Members,

I have file in which there are many records and each record has a field which has a date entry in the format of MM/DD/YY.Now the dates could be from 01/01/08 till date 12/04/08.Is there a way to filter out only records which are in the range from 01/01/08 - 07/31/08 , somewhat like between these dates only i want to select the records.Is there any function in DFSORT where we can achieve the result.I do not want to put in the INLCUDE CONDITION checking for each day from Jan 01 - Jul 31.

We can also have a leap year and record for February 29 th could also occur 02/29/08 and sometimes it could also not be a leap year , how can we do this task.

[Frank Yaeger]

You can use a DFSORT job like the following to do what you asked for. I assumed your date starts in position 1 and your input file has RECFM=FB and LRECL=80, but you can change the job as needed.

[yadav2005]

Frank,

Thanks a lot for such a quick reply.Can you help me in understanding why you have used Y2PAST=1980, what does UFF mean and you have used mask M11 with length as 6 ,i guess u are making to MMDDYY format with 6 bytes and what is Y2W.

[yadav2005]

Frank,

How should i tailor my code if my date starts at position 100 , can you please help me modifying the code.

[Frank Yaeger]

Y2PAST=1980 sets the century window from 1980-2079. So two-digit years from 80 to 99 are treated as 19yy years and two-digit years from 00-79 are treated as 20yy years. If that's not appropropriate, change it (e.g. Y2PAST=2000 would give a century window from 2000-2099).

UFF,M11,LENGTH=6 uses DFSORT's unsigned free form format (UFF) to extract the digits from your mm/dd/yy values resulting in 'mmddyy' values (e.g. 12/31/07 -> 123107).

Y2W is a DFSORT format that uses the century window to operate on an 'mmddyy' date. Y'yymmdd' is a yymmdd constant that uses the century window. Using Y2W with a Y'yymmdd' constant allows you to compare an 'mmddyy' date in a record to a 'yymmdd' constant - it handles normalizing the dates to the same form.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

[yadav2005]

Frank thanks for the explanation it is clear to me now , can you help me modifying the code if my date starts from column 100.Thanks.

[Frank Yaeger]

What is the RECFM and LRECL of the input file?
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

[yadav2005]

Frank,

The RECFM is VB and LRECL = 151 and the date field starts at pos 100.

[kolusu]

yadav2005,

Since it is a VB file, I am assuming that you already have counted the RDW in determining the position of the date field. So try these control cards