Copying half records into one file & remaning into other

VIKAS GAIKWAD · New User Joined: 30 Nov 2006 Posts: 33 Location: MUMBAI

Hi,

I have one file having 100 records in it. I want to create two files from this file.
1. Which will contain first 50 records
2. It will contain remaining 50 records.
Is there is any way to do it by using SORT?

Thanks,

Vikas.

guptae · Posted: Mon Sep 03, 2007 12:54 pm

Hi There,

You can use following JCL

Frank Yaeger · Posted: Mon Sep 03, 2007 9:21 pm

Here's a simpler way to do it with DFSORT:

VIKAS GAIKWAD · New User Joined: 30 Nov 2006 Posts: 33 Location: MUMBAI

Hi,

Thanks Ekta, Thanks Frank Above JCL's are working. I apologize the way in which I written the question.
The question is The input file may have 100 or 200 or any no. of records, I want to split input file into two files, half records in one file & remaining into another half. If Input file contains odd number of records the Int(n/2+1) into first file & remaining into second file.

Thanks,

Vikas.

murmohk1 · Posted: Wed Sep 05, 2007 12:27 pm

Vikas,

Frank's JCL holds good for your requirement.

shankar.v · Posted: Wed Sep 05, 2007 1:20 pm

Frank Yaeger · Posted: Wed Sep 05, 2007 9:16 pm

Vikas,

See the "Split a file to n output files dynamically" Smart DFSORT Trick at:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/

shankar,

When I ran your job with DFSORT, it got a RC=16. Please try your jobs to see if they work before posting them!

shankar.v · Posted: Thu Sep 06, 2007 11:05 am

Frank,

dick scherrer · Posted: Thu Sep 06, 2007 8:43 pm

Hello,

If you post a Syncsort solution in this DFSORT forum, it would at least be a good idea to mention that the suggestion was a Syncsort solution.

Frank Yaeger · Posted: Thu Sep 06, 2007 9:39 pm

Shankar,

This is the DFSORT Forum. People come here looking for a DFSORT solution. If you can't test with DFSORT, then I'd respectively suggest you not post in this Forum.

Note that while full documentation is available for DFSORT's ICETOOL, there's no documentation for Syncsort's SYNCTOOL. So you can't really look up what syntax is valid for SYNCTOOL or what the use of particular syntax will accomplish with SYNCTOOL. You can only experiment. And the DFSORT Forum is not the appropriate place for SYNCTOOL experiments.