Page 1 of 1
Regarding SortStage
Posted: Mon May 29, 2006 3:24 am
by satheesh_color
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
Posted: Mon May 29, 2006 7:19 am
by kcbland
You have data type issues. Add Transformer stages and adjust/cleanup the data accordingly.
Posted: Mon May 29, 2006 2:48 pm
by ray.wurlod
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.)
Posted: Tue May 30, 2006 12:34 am
by satheesh_color
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
Posted: Tue May 30, 2006 12:56 am
by ray.wurlod
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.
Posted: Tue May 30, 2006 1:01 am
by satheesh_color
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
Posted: Tue May 30, 2006 6:35 am
by chulett
Do you have something against Transformer stages? What happens in approach number one when you add two of them into the job stream?
Posted: Tue May 30, 2006 6:58 am
by ray.wurlod
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
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.