How to extract data less than 90 days from the Current Data



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

How to extract data less than 90 days from the Current Data

Postby N J Baruah » Sun Apr 08, 2018 4:53 pm

Hi All,

I have an input file which is having data along with a reference date. The reference date is in the format YY/MM/DD and it is present in 55-62 column. My requirement is to sort out all those data from the input file to the output which has been last referenced within 3 months i.e 90 days. I am using the below code:
______________________________________________________________________
//STEP1 EXEC PGM=ICEMAN
//SYMNAMES DD *
Cur_Date,S'&YR2./&MON./&DAY'
/*
//SORTIN DD DSN=INPUT.FILE,DISP=SHR
//SORTOUT DD DSN=OUTPUT.FILE, DISP= ....
//SYSIN DD*
OPTION COPY
INCLUDE COND=(55,8,CH,EQ,Cur_Date-90)
/*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
______________________________________________________________________

But I am not able to retrieve the data which has been last referenced within 3 months.
Can anyone please help me to correct my mistake and get the required results ?
N J Baruah
 
Posts: 12
Joined: Wed Apr 04, 2018 6:02 pm
Has thanked: 1 time
Been thanked: 0 time

Re: How to extract data less than 90 days from the Current D

Postby Robert Sample » Sun Apr 08, 2018 5:41 pm

Let's see --
You don't tell us what problem you have with your code
You don't show us job output
You don't tell us how the actual output is different from what you expect
You don't show us any SORT messages

In other words, you provided nothing for us to help you with.

Furthermore, you have ALREADY asked about this -- if you're not happy with the answers in the other topic, perhaps you should ask a better question?

Topic locked as duplicate.
Robert Sample
Global moderator
 
Posts: 3657
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 270 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post