MVSFORUMS.com

raogln · Beginner Joined: 06 Jun 2005 Posts: 2 Topics: 1

Hi all, i've a date field in my input file as yymmdd

i want to include recs with date field > current date - 151 days.

Is there anyway to do it. This is urgent. Can anyone help me pls.

kolusu · Posted: Mon Jun 06, 2005 5:45 pm Post subject:

Raogln,

The following JCL will give you the desired results. I assumed that your input date starts at pos 1 for 8 bytes.

raogln · Beginner Joined: 06 Jun 2005 Posts: 2 Topics: 1

Thanks for the solution. But my date field has only 6 bytes (format YYMMDD). Will this still work?

kolusu · Posted: Mon Jun 06, 2005 7:02 pm Post subject:

Raogln,

sure we need to tweak the control cards a bit. First you need to expand the 6 bytes of date(yymmdd) to 8 bytes(CCYYMMDD). If your input file has an lrecl of 80 bytes , then we expand the date at the end(81st byte) of every record and then validate that field to select the records.

Use the following control cards.

Frank Yaeger · Posted: Wed May 10, 2006 6:39 pm Post subject:

Here's an easier way to do this with DFSORT: