Hai,
We are using DS7.5 and with our server jobs ,while reading data from sortstage to sequential stage the data's are populated.but while reading data from sort stage to hashed file stage it gives an error as "Input column cannot populate an output column" and error number is "-100".
Our sample job's model:
SequentialStage--------------->SortStage------------------>Hashed fileStage
Regards,
Satheesh.R
Regarding SortStage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Your text specifies "reading data from sortstage to sequential stage" but your design shows something different.
Does the text file contain an empty line at the end? (I vaguely recall that -100 is the "end of data" code.)
Does the text file contain an empty line at the end? (I vaguely recall that -100 is the "end of data" code.)
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: 182
- Joined: Thu Jun 16, 2005 2:05 am
Hai Ray,
My question can we move records directly from sortstage to hashed File Stage.
1)SortStage-------->HashedFile Stage
(or)
2)SortStage------->Seq.FileStage------>HashedFileStage
While using 2nd option the job works correctly.But using 1st option it throws an error as "input col. cannot promote to an output.Col" and error -100.
Regards,
Satheesh.R
My question can we move records directly from sortstage to hashed File Stage.
1)SortStage-------->HashedFile Stage
(or)
2)SortStage------->Seq.FileStage------>HashedFileStage
While using 2nd option the job works correctly.But using 1st option it throws an error as "input col. cannot promote to an output.Col" and error -100.
Regards,
Satheesh.R
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No. The Sort stage does not read from disk. It requires an input link.
You can, however, specify the UNIX sort command as a filter in a Sequential File stage.
You can, however, specify the UNIX sort command as a filter in a Sequential File stage.
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: 182
- Joined: Thu Jun 16, 2005 2:05 am
Hai ray,
Sorry for disturb you again ray:
1)Seq.FileStage------>SortStage----->Hashed.FileStage
2)Seq.FileStage------>SortStage---->Seq.FileStage----->HashedStage.
While using 2nd option the job works correctly.But using 1st option it throws an error as "input col. cannot promote to an output.Col" and error -100.
Regards,
Satheesh.R
Sorry for disturb you again ray:
1)Seq.FileStage------>SortStage----->Hashed.FileStage
2)Seq.FileStage------>SortStage---->Seq.FileStage----->HashedStage.
While using 2nd option the job works correctly.But using 1st option it throws an error as "input col. cannot promote to an output.Col" and error -100.
Regards,
Satheesh.R
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not enough information. This question can only be answered with detailed knowledge about the metadata on each of the links, and complete and accurate reporting of error and warning messages.satheesh_color wrote:Hai ray,
Sorry for disturb you again ray:
1)Seq.FileStage------>SortStage----->Hashed.FileStage
2)Seq.FileStage------>SortStage---->Seq.FileStage----->HashedStage.
While using 2nd option the job works correctly.But using 1st option it throws an error as "input col. cannot promote to an output.Col" and error -100.
Regards,
Satheesh.R
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.