Key field starts at first 8 bytes Numeric value.
Each proper record is 20 bytes length. So another key field can start only at 21st or 41st or 61st in a single row.
Each row may contain more than 1 proper record(20 bytes max) but upto 4 proper records.
Each row in the input file may contain maximum of 4 key fields or 3 or 2 or 1 or nothing.
Key fields start with special characters or anything other than numeric can be excluded from that row.
Here is the sample output file
With z/OS DFSORT V1R10 PTF UK90025 or z/OS DFSORT V1R12 PTF UK90026 (Oct,2010), you can now use the new RESIZE operator of DFSORT's ICETOOL to easily create larger records from smaller records, or smaller records from larger records.
Use the following DFSORT/ICETOOL JCL which will give you the desired results.
Here every proper record starts at 9th position with length of 20 bytes.
From 29th position (i.e end of first proper record) to 32nd pos (length 4 bytes) are junk values and so next proper record will start 4 bytes later than the previuos proper record.
Next proper record starts at 33 and another one starts at 57.
Each proper record's length is 20 bytes.
I would like to learn more about data format like FS - Floating Sign, etc.. and its usage. Please guide.
If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from: