Record Date Difference in OUTREC



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

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:
 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!
bmalek
 
Posts: 2
Joined: Tue Sep 09, 2014 11:35 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Record Date Difference in OUTREC

 

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
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

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!
bmalek
 
Posts: 2
Joined: Tue Sep 09, 2014 11:35 pm
Has thanked: 0 time
Been thanked: 0 time

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
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post