Incrementing a sequence number in Header for each Job Run



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

Re: Incrementing a sequence number in Header for each Job Ru

Postby BillyBoyo » Wed Dec 12, 2012 6:52 pm

A couple more things. You're not actually doing any "incrementing". Did you go with the idea of maintaining a run-sequence control file separately?

Also, if you are able to identify the header, then you'd not need the sequence-number generation for each record.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Re: Incrementing a sequence number in Header for each Job Ru

 

Re: Incrementing a sequence number in Header for each Job Ru

Postby shiitiizz » Wed Dec 12, 2012 7:27 pm

Hi Billy, yea for some reasons business has asked us to maintain 15 digit seq.

Also for SYMNAMES I created a flat file with LRECL=80, RECFM=FB instead of using a temp data set.

Also, with the tem dataset name changed to &&temp* the job worked fine :)
shiitiizz
 
Posts: 15
Joined: Thu Dec 06, 2012 2:30 pm
Has thanked: 3 times
Been thanked: 0 time

Re: Incrementing a sequence number in Header for each Job Ru

Postby BillyBoyo » Wed Dec 12, 2012 7:47 pm

Up to 999,999,999,999,999 records? of 536 bytes each?

OK, it is really, really, going to help if you can identify the header without using the sequence-number approach, if you have a file even remotely approaching that size.

It would frankly be "nuts" to pass through some huge amount of data, just to update the sequence number for such a file.

I think you need to get some clarification. Find out the expected initial size of the file, dummy up some records, find how long it takes, take file growth into account and do some estimates for one year, two years, whatever, then go back to the requirement-giver and see if they are happy.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Incrementing a sequence number in Header for each Job Ru

Postby NicC » Wed Dec 12, 2012 8:31 pm

As the sort product in question is SYNCSORT (WER messages)I have moved the topic to that forum.
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: Incrementing a sequence number in Header for each Job Ru

Postby shreya19 » Wed Aug 27, 2014 7:56 pm

Hi,

I am using the same JCL for incrementing sequence numbers. I am facing the same issue as mentioned by you:

This job is going thru fine but is not appending the sequence number in File 2.
If you could kindly assist me where I am going wrong.

Can you please tell, how this was corrected?
shreya19
 
Posts: 6
Joined: Thu Mar 13, 2014 9:15 pm
Has thanked: 0 time
Been thanked: 0 time

Previous

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post