IBM Mainframe Forum

Hi Good Day !!

I'm trying find a way to alter the records in a GROUP. I wanted to bring in the THIRD record in a group as FRIST record, would it be possible to make it that way ? Can someone help. Mentioned below is an example that i'm looking at. RECFM=FB and LRECL=200.



Once the group is identified with the above criteria, i'm want to know to how to push the THIRD record as FIRST one in the GROUP.



Appreciate the response.

Thank You.
Rajesh.

If you identify sequence-within-the-group as being three, then you can set it to, say, zero. Sort the file with the sequence number of the type you have just adjusted after the rest of the group stuff.

Hi Billy,

Can you please be more elaborate ? how do i set the sequence number as ZERO after initially identifying it as THREE.

Thank You.
Rajesh.

In the position where you have the sequence for the group, and you have identified it as number three, simply put zero there (a zero of the same size and type as the sequence number).

so



Then you can drop all the extra stuff as no longer needed.

The original third record in the group should now be the first.

Understood. And it worked.


Thank You Billy.
Rajesh.

Good for you. I think you can streamline things a little, perhaps to one step. For instance, can the final sort could be in step-2 with INREC instead of OUTREC? You have a working solution you got to yourself, so if that leaves you with time, see if you can smarten it up a bit. It is a useful exercise, as you will end up knowing what you can do where in the sort process. Check your manual.

Just as an afterthought, what if there is no third record? Which should appear as the first? As an exercise, even if not possible with your actual data, how about trying 2nd record first, if only two records?