How to Add seq as alphabetic



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Re: How to Add seq as alphabetic

Postby enrico-sorichetti » Fri Jul 31, 2015 4:42 pm

... :o

unfortunately the solution You posted has nothing in common with the original requirement
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2644
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: Re: How to Add seq as alphabetic

 

Re: How to Add seq as alphabetic

Postby BillyBoyo » Fri Jul 31, 2015 5:05 pm

Yes, it looks like you have another step which is appending a two-digit sequence number to your data. This is not necessary.

  OPTION COPY
  INREC OVERLAY=(26:SEQNUM,1,BI,START=1,RESTART=(1,11),
                 26:26,1,CHANGE=(1,
                                 X'01',C'A',
                                 X'02',C'B',
                                 X'03',C'C',
                                 X'04',C'D',
                                 X'05',C'E',
                                 X'06',C'F',
                                 X'07',C'G'))


This gives you:

50015662008              A0001-IBW82U20150702
50015662008              B0001-IBVWME20150702
50015662008              C0001-IBVXME20150702
50015662008              D0001-IBVYME20150702
50015662001              A0001-IBVAME20150702
50015662001              B0001-IBVBME20150702
50015662001              C0001-IBVBME20150702
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Previous

Return to DFSORT/ICETOOL/ICEGENER