Regarding SortStage

satheesh_color · Post by **satheesh_color** » Mon May 29, 2006 3:24 am

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

kcbland · Post by **kcbland** » Mon May 29, 2006 7:19 am

You have data type issues. Add Transformer stages and adjust/cleanup the data accordingly.

ray.wurlod · Post by **ray.wurlod** » Mon May 29, 2006 2:48 pm

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.)

satheesh_color · Post by **satheesh_color** » Tue May 30, 2006 12:34 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

ray.wurlod · Post by **ray.wurlod** » Tue May 30, 2006 12:56 am

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.

satheesh_color · Post by **satheesh_color** » Tue May 30, 2006 1:01 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

chulett · Post by **chulett** » Tue May 30, 2006 6:35 am

Do you have something against Transformer stages? What happens in approach number one when you add two of them into the job stream?

ray.wurlod · Post by **ray.wurlod** » Tue May 30, 2006 6:58 am

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.