How to split the record without specifying key value?

JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...
sathyasri
Posts: 11
Joined: Tue Oct 09, 2007 6:06 pm
Skillset: pl1,ims
Referer: google

How to split the record without specifying key value?

Postby sathyasri » Fri Jan 11, 2008 1:40 pm

for example I want to split the record based on id field.But in my id field i have various value like D,E,7..(There are thousands of record..its very difficult to identify the values in the id field Record )Then how to split the record based on my id field? Is there any steps in jcl..?
If we using outrec like OUTREC FIELDS=(1,10,C' 1'} it must to give the key value inside the quotes..

arunprasad.k
Posts: 110
Joined: Thu Dec 27, 2007 5:18 pm
Skillset: Known little stuffs to answer a few queries!!
Referer: Google
Contact:

Re: How to split the record without specifying key value?

Postby arunprasad.k » Fri Jan 11, 2008 5:41 pm

sathyasri,

Please post some example input records and the desired output. This will help those people who would like to help you.

Arun.

User avatar
Frank Yaeger
Global moderator
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Skillset: DFSORT, ICETOOL, ICEGENER
Referer: Search
Contact:

Re: How to split the record without specifying key value?

Postby Frank Yaeger » Fri Jan 11, 2008 10:16 pm

sathyasri,

It's not clear what you're trying to do. Do you mean that you want a different output file for every possible different value in an id field without actually identifying the possible values in the id field? For a 1-byte field, that would be 256 data output sets. For a 2-byte field, that would be 65535 possible output data sets.

You need to explain more clearly what you're trying to do with exact details and examples.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort