CA 1 Flexible Storage

 View Only
Expand all | Collapse all

how to  extract only one date using from_date in earl copy book TMEDSN02

  • 1.  how to  extract only one date using from_date in earl copy book TMEDSN02

    Posted Jan 08, 2018 10:42 AM

    how to  extract only one date using from_date in earl copy book TMEDSN02



  • 2.  Re: how to  extract only one date using from_date in earl copy book TMEDSN02
    Best Answer

    Broadcom Employee
    Posted Jan 09, 2018 08:56 AM

    Hello,

    The From_Date should be at less today's´date or greater.

    You can do this by modifying the beginning of the EARL in this area:

    ! THE FORMAT FOR FROM_DATE AND TO_DATE IS CYYNNN.  
    ! Century bit will be '1'.                         
    ! April 11, 2007 would be 107101.                  
    ! THE FORMAT FOR FROM_DAYS AND TO_DAYS IS NNN.     
    !                                                  
                                                       
     DEF FROM_DATE       (P 7.0) = 118012              
     DEF FROM_DAYS       (P 7.0) = 0                   
                                                       
     DEF TO_DATE         (P 7.0) = 118100              
     DEF TO_DAYS         (P 7.0) = 0                   

     

    As you can see I do a forecast from January 12th till April 10th. As you can see above the format to use is explained.

    let me know if that match your needs.

    Pierre