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
Sort stage is not wrking
Moderators: chulett, rschirm, roy
Sort stage is not wrking
Last edited by atul9806 on Wed Mar 07, 2012 2:04 am, edited 2 times in total.
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
Atul, try giving like this
Code: Select all
#sorting#,#columnname#
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!