Sort stage is not wrking

atul9806 · Post by **atul9806** » Wed Mar 07, 2012 1:35 am

Hi guys
I am creating a server job, in which taking input from one table and applied sort stage to sort the table with a column and stor the data into other table
job is running fine, but not sorting the table

I used the <column_name> <D>
for order by column name desc.

Please suggest

Thanks
Atul

kandyshandy · Post by **kandyshandy** » Wed Mar 07, 2012 1:55 am

You should give "Sort criteria, defining which Input Link's Column Names to sort on."

atul9806 · Post by **atul9806** » Wed Mar 07, 2012 2:02 am

Hi there
this is my sorting criteria. I am taking the input from the user

Please help

ray.wurlod · Post by **ray.wurlod** » Wed Mar 07, 2012 4:23 am

Sort probably is working, but the database server for your target table is storing rows in whatever order it feels like. It is a fundamental tenet of databases that storage order is under control only of the database engine.

kandyshandy · Post by **kandyshandy** » Wed Mar 07, 2012 4:49 am

Atul, try giving like this

Code: Select all

#sorting#,#columnname#

chulett · Post by **chulett** » Wed Mar 07, 2012 7:42 am

You are missing a fundamental point, the one Ray pointed out. To check your sorting, run the output to a flat file - tables have no 'sort' to them. If you want data out in a certain order, use an order by.

atul9806 · Post by **atul9806** » Sun Mar 18, 2012 2:00 pm

yes guys, you are right... I got the sorted data in a flat file
thanks again