Sorting in Server Jobs
Moderators: chulett, rschirm, roy
Sorting in Server Jobs
Hi,
I want to do sort in a server job. I tried to get help for server SORT stage but couldnt. Can anyone help me out what options has to be set in SORT stage with some example plz.
Thanks.
I want to do sort in a server job. I tried to get help for server SORT stage but couldnt. Can anyone help me out what options has to be set in SORT stage with some example plz.
Thanks.
The two biggest things to know are:
1. Never leave the Temporary Directory empty as that puts all work files in the Project
2. How to enter the Sort Specifications
The sort specs are simply a column separated list of the columns to sort on (in that order) and the 'direction' to sort:
A or ASC = ascending, case insensitive
D or DESC = descending, case insentive
a or asc = ascending, case sensitive
d or desc = descending, case sensitive
You can also supply a custom collation order using an 'external character map' but let's not worry about that quite yet.
1. Never leave the Temporary Directory empty as that puts all work files in the Project
2. How to enter the Sort Specifications
The sort specs are simply a column separated list of the columns to sort on (in that order) and the 'direction' to sort:
Code: Select all
Column_A asc, Column_B ASC, Column_C desc
D or DESC = descending, case insentive
a or asc = ascending, case sensitive
d or desc = descending, case sensitive
You can also supply a custom collation order using an 'external character map' but let's not worry about that quite yet.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
The two biggest things to know are:
1. Never leave the Temporary Directory empty as that puts all work files in the Project
2. How to enter the Sort Specifications
The sort specs are simply a column separated list of the columns to sort on (in that order) and the 'direction' to sort:
A or ASC = ascending, case insensitive
D or DESC = descending, case insentive
a or asc = ascending, case sensitive
d or desc = descending, case sensitive
You can also supply a custom collation order using an 'external character map' but let's not worry about that quite yet.
1. Never leave the Temporary Directory empty as that puts all work files in the Project
2. How to enter the Sort Specifications
The sort specs are simply a column separated list of the columns to sort on (in that order) and the 'direction' to sort:
Code: Select all
Column_A asc, Column_B ASC, Column_C desc
D or DESC = descending, case insentive
a or asc = ascending, case sensitive
d or desc = descending, case sensitive
You can also supply a custom collation order using an 'external character map' but let's not worry about that quite yet.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 1
- Joined: Mon Feb 13, 2006 11:00 am
Re: Sorting in Server Jobs
Now, can someone tell me how to sort the entire record using a server sort.
I have 1013 Rows
With column structure: RTC OTC RecType ...
RTC and OTC are Keys and columns I need to sort by.
I have 1013 Rows
With column structure: RTC OTC RecType ...
RTC and OTC are Keys and columns I need to sort by.