How to identify last record in each group of records

Ambili S · Active User Joined: 06 Sep 2007 Posts: 112 Location: India

Hi

In the below e.g. how to identify the end of a group of records.

Record type A - appears for each customer no. in file. Record type B is the customer details.Both A and B are in position 1. The no.of times B may occur for a customer is not fixed.

A
B
B
B
A
B
B
B
B
A
B
A
B
B

Using when=group , the records are grouped, so basically the first 4 records are a group as they are details of a customer. Then the next 5 records are details of another customer. SEQNUM with RESTART doesnt seem to work when tried with INREC IFTHEN=(WHEN=GROUP) option.

Is there any way to identify the end of a group here ? i.e the last record in each group ?

The o/p should have A , the 1st B and last B in each group.

Thanks

Bill Woodger · Posted: Thu Jun 11, 2015 11:43 pm

If you start with this topic, and follow the links, you should find sufficient to allow you to identify the last, and then select with OUTFIL OMIT=/INCLUDE=.

Ambili S · Active User Joined: 06 Sep 2007 Posts: 112 Location: India

Hi Bill
If you can share the links it will be of great help. I will go through them.

Thanks

Bill Woodger · Posted: Fri Jun 12, 2015 11:48 am

Sorry about that, I've updated the original. Yesterday was not a good day for typing.

Ambili S · Active User Joined: 06 Sep 2007 Posts: 112 Location: India

Thanks Bill. I read your post in the link - www.ibmmainframes.com/viewtopic.php?p=300686#300686 of using same input twice.