Hi Kolusu, Here is the actual production files data ,
102,3522850,15,FF,9 202,3522850,15,FF,9 102016,3522850,15,FF,9 104152,3522850,15,FF,7 104152,3522850,15,FF,9 104760,3521499,15,FF,9 104760,3521499,15,FF,9 106735,3507181,15,FF,9 989898989,3507181,15,FF,9 989898989,3507181,15,FF,9 so the o/p need to be 1,102,3522850,15,FF,9 1,202,3522850,15,FF,9 1,102016,3522850,15,FF,9 1,104152,3522850,15,FF,7 2,104152,3522850,15,FF,9 1,104760,3521499,15,FF,9 2,104760,3521499,15,FF,9 1,106735,3507181,15,FF,9 1,989898989,3507181,15,FF,9 so here if we do a SORT and put a SEQNUM , is it going to work ? we see that in the input file the length of the 1'st column is not same for all of the rows . Please suggest how to address this ? Regards Ron T ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN