Using sort stage

kdronam · Post by **kdronam** » Wed Jul 24, 2002 2:11 pm

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.

cmueller · Post by **cmueller** » Tue Jul 30, 2002 7:20 am

The sort specification in the sort stage is case sensitive, check your input sequential stage, specifically 'DSLink3.date'.

Oancea · Post by **Oancea** » Wed Aug 25, 2004 8:50 am

kdronam wrote:Error as following
sorttest..sort1: Internal Error: sort specification error, function create_sort_spec returned [Invalid column 'DSLink3.date' in sort specification]

Sort specification has this format:
<ColumnName> <Order> [, <ColumnName> <Order>, ...]
where <Order> take 'ASC' or 'D' values (it's not case sensitive)
In your case, type: date asc

chulett · Post by **chulett** » Wed Aug 25, 2004 9:01 am

Don't use link name in the sort spec, simply specify the column names.

ketfos · Post by **ketfos** » Sun Dec 25, 2011 11:37 am

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

pandeesh · Post by **pandeesh** » Sun Dec 25, 2011 12:39 pm

Hi,
What are your input columns and what you are specifying as keys in sort stage?

ketfos · Post by **ketfos** » Sun Dec 25, 2011 1:06 pm

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

ray.wurlod · Post by **ray.wurlod** » Sun Dec 25, 2011 3:47 pm

Did you give the name of the column followed by a space then one of asc, ASC, desc or DESC ?

ketfos · Post by **ketfos** » Sun Dec 25, 2011 4:43 pm

I did not give the name of the column followed by asc or desc.

After reading your email, i did give the name of column, followed by asc.

The job now runs correct.

Thanks Ray.

1. Where in the documentation I can see this syntax of sort to specify sort order?

Ketfos

ray.wurlod · Post by **ray.wurlod** » Sun Dec 25, 2011 8:09 pm

My guess would be the Sort stage chapter in the Server Job Developer's Guide.

ketfos · Post by **ketfos** » Sun Dec 25, 2011 8:56 pm

I reading the Websphere Datastage Server Job Guide - 46desjd.pdf
The Chapter 4
mentions all the stages below expect SOrt Stage.
1. Folder
2. Seq File
3. hash File
4.Aggregator
5.Merge
6. Transformer
7. Link Collector and Partition
8.IPC
9. Command
10. Ftp

Ketfos

pandeesh · Post by **pandeesh** » Sun Dec 25, 2011 10:45 pm

Ketfos,
I believe your problem gets resolved.
So can you please resolve this topic?

Thanks

ketfos · Post by **ketfos** » Sun Dec 25, 2011 11:33 pm

Where do I click to maark it resolved?

pandeesh · Post by **pandeesh** » Sun Dec 25, 2011 11:44 pm

You can find the button at the top of te page as mark topic:resolved .

ketfos · Post by **ketfos** » Sun Dec 25, 2011 11:57 pm

I am not orignal author.

I have opened an old post which had the same error message but there was no clear resolution.

hence I cannot close the issue, athough my problem is resolved after inputs from Ray.

Ketfos

DSXchange

Using sort stage

Using sort stage

Re: Using sort stage