Hi Guys,
just wondering if this is possible in one DFSORT step, I know I can do this by doing it in chunks then rejoining the file afterwards but wondered if it's possible in just one sort step.
Basically I have a list of customers and I want to create an dummy national insurance number for each of them.
So far i've come up with the following which just about gives me what I want but I also want to add a Character onto the end, but as there are well over a million customers I want the first million customers to have an A suffix, the next million, a B suffix, the next million a C suffix etc etc.
Sortin
000000386
000000388
...(nearly one million records further down the file)
358183249
358183250
358183251
358183252
Joined: 08 May 2006 Posts: 1193 Location: Dublin, Ireland
How many millions of records might you have?
If you change INREC to use SEQNUM,7,ZD (for example), you could check the high-order for '0', '1, '2,.... '9' and BUILD your required output record dropping the extgra higfh-order digit...