Is there any function to sort the data??

surendra_ds · Post by **surendra_ds** » Fri Jul 20, 2007 9:37 am

Hi All

Is there any function to sort the data in server jobs( Not UNIX commonds)

My requirement is to capture the duplicated data from source file
my source is CSV file, I dont have SORT Stage in our project.If we have SORT Stage , we can sort the data and capture the duplicate by comparing current and previous records.
Please help me to solve this problem.
My server is on windows machine , so I can'nt use the UNIX sort command.
Thanks in advance

DSguru2B · Post by **DSguru2B** » Fri Jul 20, 2007 10:32 am

You dont have a sort stage

?
You might not be able to see it in the stages pallete but if you go via the repository, you will see that the sort stage exists. If its truely missing then contact your support provider to get it.

surendra_ds · Post by **surendra_ds** » Fri Jul 20, 2007 10:40 am

DSguru2B wrote:You dont have a sort stage ?
You might not be able to see it in the stages pallete but if you go via the repository, you will see that the sort stage exists. If its truely missing then contact your support provider to get it.

Hi DSguru2B

we dont have SORT stage , i have searched thru Repository.Can we solve this problem with out SORT Stage???

DSguru2B · Post by **DSguru2B** » Fri Jul 20, 2007 12:16 pm

There is a windoze sort funtion but I am not sure if that is going to be of any help. Look into it though.
As a workaround you can load your flat file in a temp table and pass an order by clause there.
I still say get back to IBM and ask for the sort stage. Its an important stage, especially if you are sitting on a windoze box.

surendra_ds · Post by **surendra_ds** » Fri Jul 20, 2007 1:51 pm

Thanks DSguru2B

Thanks for ur reply...
I solved the problem by using Hash File and UNIVESRSE stage..

chulett · Post by **chulett** » Fri Jul 20, 2007 7:24 pm

Talk to your admin, have them install the Sort stage. No need to 'get back to IBM' for that, someone just didn't bother to install it when they installed everything else. Probably several other optional plug-in stages you are 'missing' as well...