|
View previous topic :: View next topic
|
| Author |
Message |
Itanium
Active User
Joined: 22 Jan 2006
Posts: 114
Location: India
|
|
|
|
Below is my input
AAAAAAA
AAAAAAA
AAAAAAA
BBBBBBB
BBBBBBB
BBBBBBB
CCCCCC
CCCCCC
and the output shud look like,
AAAAAAA 001
AAAAAAA 002
AAAAAAA 003
BBBBBBB 001
BBBBBBB 002
BBBBBBB 003
CCCCCC 001
CCCCCC 002
Thanks. |
|
| Back to top |
|
 |
krisprems
Active Member
Joined: 27 Nov 2006
Posts: 649
Location: India
|
|
|
|
Itanium
Here is the SORT CARD for your requirement.
| Code: |
SORT FIELDS=COPY
OUTREC OVERLAY=(8:SEQNUM,3,PD) |
|
|
| Back to top |
|
|
krisprems
Active Member
Joined: 27 Nov 2006
Posts: 649
Location: India
|
|
|
|
sorry data format shd be ZD not PD,
| Code: |
FIELDS=COPY
OUTREC OVERLAY=(8:SEQNUM,3,ZD) |
|
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
krisprems,
This
| krisprems wrote: |
| Code: |
FIELDS=COPY
OUTREC OVERLAY=(8:SEQNUM,3,ZD) |
|
will not work for OPs request. This SORT'll append sequence no. in asscending order in output irrespective of where input-records change their alphabetic-sequence.
Look the output, OP has posted:
AAAAAAA 001
AAAAAAA 002
AAAAAAA 003
BBBBBBB 001
BBBBBBB 002
BBBBBBB 003
CCCCCC 001
CCCCCC 002
I hope you got it, when input records change from AAAAAAA to BBBBBBB etc. , sequence no. in output has to start from '001'. |
|
| Back to top |
|
|
krisprems
Active Member
Joined: 27 Nov 2006
Posts: 649
Location: India
|
|
|
|
Thanks for awakening me anuj 
Itanium
Here is the sort card for your reuquest
| Code: |
//*******************************************************
//STEP1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
AAAAAAA
AAAAAAA
AAAAAAA
BBBBBBB
BBBBBBB
BBBBBBB
CCCCCCC
CCCCCCC
/*
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
OUTREC OVERLAY=(9:SEQNUM,3,ZD,RESTART=(1,7))
/*
|
The o/p SORTOUT conatins
| Code: |
----+----1-
AAAAAAA 001
AAAAAAA 002
AAAAAAA 003
BBBBBBB 001
BBBBBBB 002
BBBBBBB 003
CCCCCCC 001
CCCCCCC 002
|
|
|
| Back to top |
|
|
Itanium
Active User
Joined: 22 Jan 2006
Posts: 114
Location: India
|
|
|
|
| This works...Thanks a lot |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| krisprems wrote: |
| Thanks for awakening me anuj |
You're welcome 
| Code: |
| OUTREC OVERLAY=(9:SEQNUM,3,ZD,RESTART=(1,7)) |
Was expecting RESTART parameter only.  |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| anuj_model wrote: |
| Was expecting RESTART parameter only. |
Don't we have some other parameter in SORT to serve the same purpose? |
|
| Back to top |
|
|
|
|
