View previous topic :: View next topic |
Author |
Message |
Martin Beginner
![](images/avatars/gallery/starwars/swars017.gif)
Joined: 20 Mar 2006 Posts: 133 Topics: 58
|
Posted: Tue Jan 16, 2007 3:11 am Post subject: Replace at regular intervals. |
|
|
Here's the input
abcd 789 789 789 789
abcd
abcd xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Output
abcd 789 789 789 789
abcd 789 789 789 789
abcd 789 789 789 789 |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
dbzTHEdinosauer Supermod
Joined: 20 Oct 2006 Posts: 1411 Topics: 26 Location: germany
|
Posted: Tue Jan 16, 2007 3:28 am Post subject: |
|
|
what is:- input record length
- output record length
- key position/len
assuming you want:- key is relative location 0, length 4
- first instance of a key, the data (relative location 4, len of record-len - 4) is overlayed on each consecutive record until key changes
are the records already sorted by the key?
Frank or someone else will come along and provide the answer, but reading thru previous post in this forum indicates that this kind of info is necessary to provide a solution. _________________ Dick Brenholtz
American living in Varel, Germany |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Frank Yaeger Sort Forum Moderator
![Sort Forum Moderator Sort Forum Moderator](images/ranks/profrat.jpg)
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
|
Posted: Tue Jan 16, 2007 11:58 am Post subject: |
|
|
Martin,
You haven't given enough information for anyone to help you. You need to explain in detail what you're trying to do. What are the "rules" for getting from input to output? What is the RECFM and LRECL of the input file? Show an example of the input and output records that illustrates the variations you can have. _________________ 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 |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Martin Beginner
![](images/avatars/gallery/starwars/swars017.gif)
Joined: 20 Mar 2006 Posts: 133 Topics: 58
|
Posted: Fri Jan 19, 2007 1:37 am Post subject: |
|
|
Frank Yaeger,
Here's the exact requirements.
LRECL :- 1800
RECFM=FB
Rules: -
- There are 2 records for every employee and we need sum up all his sal and other details which come in at regular intervals ( Sal @ Pos 22 , contr @ 72 (Sal Pos + 50 .. So on till 1672). |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
kolusu Site Admin
![Site Admin Site Admin](images/ranks/adminpic.jpg)
Joined: 26 Nov 2002 Posts: 12366 Topics: 75 Location: San Jose
|
Posted: Fri Jan 19, 2007 9:15 am Post subject: |
|
|
Martin,
You need to learn to spell out your requirement properly. Post detailed information on what you're trying to accomplish. Do not make people guess what you mean. This will give you a much better chance of getting a good answer to your question.
The latest requirement does NOT match the output you described in the first post.
post a sample input and desired output along with the dcb properties.
Kolusu _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
|
|