Using sort stage
Moderators: chulett, rschirm, roy
Using sort stage
I'm new to DataStage.
Can you please suggest on how to use the sort stage.
I'm having trouble in getting it working.
I have a simple test in which I have a seq.file
passed to sort stage and output to a sorted seq. file
Error as following
sorttest..sort1: Internal Error: sort specification error, function create_sort_spec returned [Invalid column 'DSLink3.date' in sort specification]
tried different ways without the Link etc., still no good.
Thanks in advance.
Can you please suggest on how to use the sort stage.
I'm having trouble in getting it working.
I have a simple test in which I have a seq.file
passed to sort stage and output to a sorted seq. file
Error as following
sorttest..sort1: Internal Error: sort specification error, function create_sort_spec returned [Invalid column 'DSLink3.date' in sort specification]
tried different ways without the Link etc., still no good.
Thanks in advance.
Re: Using sort stage
Sort specification has this format:kdronam wrote:Error as following
sorttest..sort1: Internal Error: sort specification error, function create_sort_spec returned [Invalid column 'DSLink3.date' in sort specification]
<ColumnName> <Order> [, <ColumnName> <Order>, ...]
where <Order> take 'ASC' or 'D' values (it's not case sensitive)
In your case, type: date asc
Hi, This is an old link and I am getting the sam error and the solution mentioned in this post did not help.
sort..Sort_1: Internal Error: sort specification error, function create_sort_spec returned [DSTAGE-SORT-0059`:`Invalid sort specification]
In the sort specifications, i specify the column name and temp directory name. Other parmeters are default.
What else is required?
THanks
Ketfos
sort..Sort_1: Internal Error: sort specification error, function create_sort_spec returned [DSTAGE-SORT-0059`:`Invalid sort specification]
In the sort specifications, i specify the column name and temp directory name. Other parmeters are default.
What else is required?
THanks
Ketfos
ketfos
My source is the database. I do not want to use order by in database SQL.
That is why I using sort stage.
In Sort Specifications , I give the name of the column on which I want to sort.
In temporary directory, I give name of the Unix directory
In input columns, i chose all columns and specify a key column.
In output columns, i chose all columns and specify a key column.
Thanks
Ketfos
That is why I using sort stage.
In Sort Specifications , I give the name of the column on which I want to sort.
In temporary directory, I give name of the Unix directory
In input columns, i chose all columns and specify a key column.
In output columns, i chose all columns and specify a key column.
Thanks
Ketfos
ketfos
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: