How canI sort data without using Sort stage?

[deva]

Hi,
How to sort the data using datastage without using sort stage?

Can any one tell me how to use the UNIX sort commond in transformer?

I am using Datastage 8 version and HP unix.

Thanks in advance.

[betterthanever]

[quote]
How can I sort data using datastage without using the sort stage?

Can anyone tell me how to use the UNIX sort commond in transformer?[/quote]

you can sort the data in the transformer based on a key

[major]

You can use sort command in before/after job sub routine in job properties

[mk_ds09]

Check the input properties of the transformers, there is option of partitioning, in that there is option of sort
1. Stable :- This is for previously sorted datasets..
2. Uniqe :- This will retain only first record if there are duplicates on the sorting key values.

hope this helps

-----------------
MK

[deva]

Check the input properties of the transformers, there is option of partitioning, in that there is option of sort
1. Stable :- This is for previously sorted datasets..
2. Uniq :- This will retain only first record if there are duplicates on the sorting key values.

hope this helps

-----------------
MK

I want to sort the file data in the transwarmer. Can you please give me the statement for befou/after routine

[ray.wurlod]

Check the input properties of the transformers, there is option of partitioning, in that there is option of sort
1. Stable :- This is for previously sorted datasets..
2. Uniq :- This will retain only first record if there are duplicates on the sorting key values.

hope this helps

-----------------
MK

No help at all - this is a server job.

[ray.wurlod]

If the data are coming from a database table, you can include an ORDER BY clause in the extraction SQL.

If the data are coming from a file you can use an operating system level sort utility to sort that file - you can do that in a before-job subroutine as mentioned or in a Filter command to the Sequential File stage.