MVSFORUMS.com

sateesh_gontla · Posted: Mon May 15, 2006 3:48 pm Post subject: Data extract

Hi

I have a 5 digit value in the file from 25th position and it is in sort order. I want to split the data into different files based on that 5 Digits.

For Ex : If I have a 10 different 5 Digit values then I need the data to be copied into 10 different files.

Any idea ?

Thanks.

Frank Yaeger · Posted: Mon May 15, 2006 4:12 pm Post subject:

Do you know the different 5 digits values ahead of time so you could hardcode them? Or are you trying to do it all dynamically based on whatever set of 5 digits values happens to be in the file (I suspect you're not expecting to have the maximum of 99999 output data sets - right? So what is the maximum?). What would the parameters for your output DD statements look like (SPACE, UNIT, etc)?
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

sateesh_gontla · Posted: Mon May 15, 2006 5:28 pm Post subject:

Hi

The max 5 Digit values would be around 25, the record length is 1000.

thx.

Frank Yaeger · Posted: Mon May 15, 2006 5:36 pm Post subject:

How about answering the rest of my questions?
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

Phantom · Posted: Thu May 18, 2006 1:35 am Post subject:

Sateesh,

It would be nice if you give a sample input and expected output along with all other required info like LRECL & RECFM of your input and output files. This would save time not only for you but for us too. A One liner cannot fetch u any solution.

Please go thro' the forum rules and try to follow them.

Thanks,
Phantom