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.
There are no sort keys in the dataset schema
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
If not, please start a new thread with your exact problem.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 45
- Joined: Wed May 02, 2007 8:30 am
- Location: Prague, Czech Republic
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
I am also having similar warnings in my job.
![Sad :(](./images/smilies/icon_sad.gif)
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 45
- Joined: Wed May 02, 2007 8:30 am
- Location: Prague, Czech Republic