Need the numseq add 1 when the key change

elmister · New User Joined: 27 Nov 2005 Posts: 14

hI, I need to do the following:

I have a file with the following key:
AAA
AAA
AAA
BBB
BBB
BBB
CCC
CCC
CCC

and i need an output file with the following:

AAA 001
AAA 001
AAA 001
BBB 002
BBB 002
BBB 002
CCC 003
CCC 003
CCC 003

I need the numseq add 1 when the key change.

Thanks in advance

Frank Yaeger · Posted: Thu Dec 04, 2008 12:29 am

Here's a DFSORT job that will do what you asked for. It uses DFSORT's new WHEN=GROUP function available with z/OS DFSORT V1R5 PTF UK90013 (July, 2008). If you don't have that PTF, ask your System Programmer to install it (it's free).