Record Date Difference in OUTREC

Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL
bmalek
Posts: 2
Joined: Tue Sep 09, 2014 11:35 pm
Skillset: Intermediate
Referer: Google

Record Date Difference in OUTREC

Postby bmalek » Tue Sep 09, 2014 11:41 pm

Hello all :)

I have a JCL that splits an input file into multiple output files and counts how many times this is done by adding a 1 to the OUTREC in various buckets:

Code: Select all

 SORT FIELDS=(37,8,CH,A,9,6,CH,A)                           
  OUTFIL FILES=(1),                                         
* FILE(1) HAS NEW TRANSMISSIONS (0 DAYS OLD)
  INCLUDE=(9,6,CH,LE,C'YYMMDD(0)',AND,                     
      9,6,CH,GT,C'YYMMDD(-1)'),                             
  OUTREC=(37,8,C'00001',C'00000',C'00000',C'00000',C'00000',
               C'00000',C'00000',C'00000',C'00000',C'00001')

The above is repeated for various age buckets.

I am trying to add the age of the record in the OUTREC, but cannot figure out how to do that based on DATEDIFF or any other methods. The date of the record starts at character 9 for 6 chars and the INCLUDE processes them correctly so I know it should be possible... Any help is greatly appreciated!

NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

Re: Record Date Difference in OUTREC

Postby NicC » Thu Sep 11, 2014 12:59 am

You do not have a JCL that does what you say - you have sort control cards that do what you say. Topic moved to DFSort. If you use another sort product then let us know.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic

bmalek
Posts: 2
Joined: Tue Sep 09, 2014 11:35 pm
Skillset: Intermediate
Referer: Google

Re: Record Date Difference in OUTREC

Postby bmalek » Thu Sep 11, 2014 8:16 pm

I'm using SyncSort, but I cannot figure out how to move the topic to that forum... Thanks!

NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

Re: Record Date Difference in OUTREC

Postby NicC » Thu Sep 11, 2014 8:52 pm

moved again.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic


  • Similar Topics
    Replies
    Views
    Last post