How to Sort data from sequential file?

taral · Post by **taral** » Fri Jun 18, 2010 2:44 am

Sorting data from sequential file.

ArndW · Post by **ArndW** » Fri Jun 18, 2010 5:01 am

Ummm.. what is wrong with using a DataStage "Sort" Stage?

chulett · Post by **chulett** » Fri Jun 18, 2010 5:40 am

Trick interview "question".

ray.wurlod · Post by **ray.wurlod** » Fri Jun 18, 2010 6:24 am

Not a question at all.

chulett · Post by **chulett** » Fri Jun 18, 2010 6:48 am

Better?

ray.wurlod · Post by **ray.wurlod** » Fri Jun 18, 2010 4:41 pm

I like Arnd's answer. If you have a third party sort utility, such as CoSort or SyncSort, then there's also scope for invoking that. If you have a UNIX emulator, such as MKS Toolkit, you could use a UNIX sort command as a filter command in the Sequential File stage itself. You could stick the data into a database table and retrieve them sorted. Lots of ways.

taral · Post by **taral** » Wed Jun 23, 2010 5:27 am

Didi not find Sort stage in Datastage 7X server

taral · Post by **taral** » Wed Jun 23, 2010 5:28 am

Didi not find Sort stage in Datastage 7X server

ArndW · Post by **ArndW** » Wed Jun 23, 2010 5:29 am

Taral,

that means you didn't look hard enough for it; it is part of the product and should be present.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 23, 2010 4:56 pm

It is present. I just checked.

Indeed, the Sort stage has been in DataStage since version 1.0.

ETLJOB · Post by **ETLJOB** » Wed Jun 23, 2010 11:07 pm

May be it is not present in the Pallete.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 24, 2010 2:55 am

It is there, in the Processing folder. Both for server jobs and for parallel jobs. (And mainframe jobs, for what it's worth.)

ETLJOB · Post by **ETLJOB** » Thu Jun 24, 2010 3:50 am

ray.wurlod wrote:It is there, in the Processing folder. Both for server jobs and for parallel jobs. (And mainframe jobs, for what it's worth.) ...

I mean, the shortcut for the "Sort stage" may be not there (shortcut removed?) in the palette . If it is the case, then one can add it using the "Customize Palette" option.