Increment text every 200 records

anaven1207 · New User Joined: 15 Jan 2008 Posts: 2 Location: India

I have an FB file of N recs. At position, say 45, I have value 'TEXT' in all the N records.

Now, for every 200 records, I need to have value as below, assuming there is enough room for overlaying this field.

TEXT1 1st 200 recs
TEXT2 Next 200 recs
TEXT3 Next 200 recs and so on.

Is it possible to achieve this using SORT ?

Frank Yaeger · Posted: Fri Jul 25, 2008 9:13 pm Post subject:

Your description is rather vague. You need to explain what you want more clearly.

What do you mean by "assuming there is enough room for overlaying this field"? Do you expect DFSORT to determine if there is enough room or not by checking for blanks? What if there isn't enough room?

What text do you want exactly in the 200th records - starting in what position?.

For record 200, you show "1st 200 recs" - is that what you really want for record 200? For record 400, you show 'Next 200 recs" - is that what you really want for record 400? What do you want for record 600, 800, etc?

What is the RECFM and LRECL of your input file?