There are no sort keys in the dataset schema

[kld05]

I changed the scale of one varchar column and now get the following warnings:

main_program: Sort key "fund_number" no longer exists in dataset schema. It will be dropped from the inserted sortmerge collector

main_program: There are no sort keys in the dataset schema. No sortmerge collector will be inserted

The referenced column "fund_number" defnitely exist. Any help is appreciated.

[samsuf2002]

is the fund_number ur primary key because we normally sort on primary keys...........

[ray.wurlod]

You change the metadata you remove the linkage into the collection of sort keys. Delete the Data Set, then re-run the job that populates it, and all should be well.

[sri1111]

I have the same issue i saw this post but dint understand what exactly i have to do, i am using a join stage with input file set and out put seq file

any helps will be appreciated

[ray.wurlod]

Does "the same issue" mean that you changed the metadata and now DataStage can not insert a Sort Merge collector because there is no sort key defined?

If not, please start a new thread with your exact problem.

[abhishekachrekar]

Hi,

I am also having similar warnings in my job.

main_program: Sort key "MCACC" no longer exists in dataset schema. It will be dropped from the inserted sortmerge collector

I am doing a join and then splitting the output into 7 output files in a transformer after the join.
The join key is MCACC.

The input file has a field MGACC which is renamed to MCACC before the join.

The output files do not contain this field MCACC, but is part of the composite key in the output files.

Please help me in removing this warning.

Regards,
Abhishek

[ray.wurlod]

Similar is not the same. Please start a new thread for this particular problem. Let's be disciplined on DSXchange, to aid future searchers.

[abhishekachrekar]

Sure Ray,

I will create a new topic.

Regards,
Abhishek