DM4/ for Previous Day



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

DM4/ for Previous Day

Postby marg » Mon Jul 15, 2013 11:56 am

Hi,

I am generating a report through JCL and the Report is to get the statistics of the previous day.

I have used DM4/ to get the current date. But could you please advise me on how to get a previous day value from DM4?

My Input File is as below:
================================
Statistics for DD/MM/CCYY
================================

My code is as below:

SORT FIELDS=COPY
INREC IFTHEN=(WHEN=(1,1,CH,NE,C'S'),BUILD=(1,180)),
IFTHEN=(WHEN=(1,1,CH,EQ,C'S'),
BUILD=(1,15,X,DATE=(DM4/)))



I use ICETOOL and the code above replaces DD/MM/CCYY with current date. But I would like to see the previous date.


Please advise.
marg
 
Posts: 4
Joined: Mon Jul 15, 2013 11:51 am
Has thanked: 0 time
Been thanked: 0 time

Re: DM4/ for Previous Day

Postby skolusu » Mon Jul 15, 2013 9:16 pm

marg,

use the following control cards
//SYSIN    DD *                                               
  OPTION COPY                                                 
  INREC IFTHEN=(WHEN=(1,1,CH,EQ,C'S'),                       
  OVERLAY=(17:10X,DATE1-1,17:33,2,C'/',31,2,C'/',27,4,8X))   
//*
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: DM4/ for Previous Day

Postby marg » Tue Jul 16, 2013 10:32 am

Thanks Kolusu.
It works.
marg
 
Posts: 4
Joined: Mon Jul 15, 2013 11:51 am
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post