regarding sort stage

avi21st · Post by **avi21st** » Mon Dec 18, 2006 1:59 pm

Hi,
odbc----->sort----->odbc
iam using sort stage , in the properties tab of sort stage.
when i enter IN THE SORT SPECIFICATIONS I ENTERED---MGR ASC.

MGR-IS THE I/P COLUMN IN MY SOURCE TABLE.
in the target table i can see the data organised by itself, what i mean is that i thought if i enter MGR ASC- It only sorts that particular column only.
but it organises another column too.
b/f sort after sort
JOB MGR JOB MGR
SALESMA N 7902 MANAGER 7605
MANAGER 7605 SALESMAN 7902
i just want to know why does it sort another columns too,it because the inorder to maintain the meaningful data.
bz in the sort specifications i just entered --- mgr asc.
when i design
odbc--->aggregator---->odbc
CONNECTED the same ODBC to sort and then sequential file.
why isn't it tansfering the records to sort component.
it just transfering the records to aggregate component.
plz help me in analyzing.

cheers;
abhi

DSguru2B · Post by **DSguru2B** » Mon Dec 18, 2006 2:06 pm

It will sort on column 'MGR' but other the rest of the columns are going to remain intact. Also, didnt get a clear picture of your second requirement.
Suggestion:
Get rid of the sort stage and put an order by MGR clause in the odbc stage. This way you will select sorted data.

avi21st · Post by **avi21st** » Mon Dec 18, 2006 2:21 pm

hi,
thanks very much.
my second query is.

source stage- odbc
iam connecting the same stage to aggregator and sort.
its transferring records to aggregator but not sort component.
why is that so happening.
i see that its performing aggregation and dumping in to target.
i want to sort the record and dump into sequential file.
to my suprise my source-ODBC is just transferring records to one i/p
its not transferring records to another i/p sort.
iam getting this error.
DataStage][SQL Client][ODBC][Oracle][ODBC][Ora]ORA-00903: invalid table name
where am i going wrong , plz help me.
cheers;
abhi
|

DSguru2B · Post by **DSguru2B** » Mon Dec 18, 2006 2:31 pm

Ok i get it now. Click on the odbc stage, from the dropdown on the outputs tab, choose the second link and add all the info for the second link again. It has nothing defined and hence your problems.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 18, 2006 2:58 pm

It sorts ROWS.
The sort key only serves to specify the basis of how to sort the rows.

This is true of every sorting mechanism, not just DataStage's.

avi21st · Post by **avi21st** » Mon Dec 18, 2006 3:01 pm

hi,
in order to eliminate sort component.
in the source stage- selection tab i have given ORDER BY MGR ASC.
iam getting error- MISSING EXPRESSION.
regarding the second query.
iam creating a link from odbc to sort and also loaded the metadata into sort component.
why doesn't it load records into sort.
plz hellp me , what should i specify in the selection tab of source stage.
plz help me.

cheers;
abhi

ray.wurlod · Post by **ray.wurlod** » Mon Dec 18, 2006 3:04 pm

Post the full error message. This is not the kind of message I would expect to see from a Sort stage. Examine the error message fully to determine which stage generates it.

DSguru2B · Post by **DSguru2B** » Mon Dec 18, 2006 4:02 pm

That error message is from the odbc stage. I think you need to put ORDER BY clause in the bottom half and not the selections tab. Cant remember whats it called, and dont have access to DS at the moment.

As per your second query, do you have the dsn name, table name all properly set for the link going to the sort stage?