i have no idea in pearl, anyways I'll learn it and get back to you if i am not able any part of the command .
I have another doubt
in the above command we are sorting the input file with one column (column 4) .how can i sort the input file (varchar sort) with two columns
For eg: in the input file first i need to sort with column 3 and then with column 4

thanks in advance