MVSFORUMS.com

[ranga_subham]

Hi,

Please provide me your suggestions/solutions to achieve the following:

A production job runs daily and creates a huge file with 'n' number of records. Except REXX, I want to use a utility (assuming SYNCSORT with COUNT) to know the 'n' number of records from this file and want to split the file into equal output files (each output file should have 1,00,000 records). How to achieve it dynamically if records vary on daily basis? On a given day we may get 5,00,000 and on the other day we may get 8,00,000 records. So, depending on the count I need to split the input file into 5 or 8 pieces for further processing. After this processing (suppose a COBOL program) I may again get 5 or 8 files. So, I need to merge all these files as single file and need to FTP it to remote customer server. How to automatize this situation?

Please provide your suggestions/solutions/ideas to this problem. Please let me know if you need more inputs/details.

Note: REXX is ruled out by customer.

Please help me out.

Thanks for your time.
_________________
Ranga
*****
None of us is as smart as all of us - Ken Blanchard

[kolusu]

ranga_subham,

Please SEARCH before posting. Check this link ( this topic shows splitting the files with 65,536 records, just change that num to the desired number).

http://www.mvsforums.com/helpboards/viewtopic.php?p=27519#27519

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[ranga_subham]

Hi Kolusu,

Thanks for the link. May I ask you this that does this solution work for SYNCSORT? We have syncsort installed at our shop.

Please suggest.

Thanks a lot once again.
_________________
Ranga
*****
None of us is as smart as all of us - Ken Blanchard

[kolusu]

[ranga_subham]

Kolusu,

Extremely sorry. Thanks for your patience.
_________________
Ranga
*****
None of us is as smart as all of us - Ken Blanchard