Preventing warnings for a reject link output file

abc123 · Post by **abc123** » Fri May 11, 2007 10:35 am

How do you prevent warnings in a reject output file from a lookup? The properties "Null field value" and "Field width" are not editable in this situation.

ds_developer · Post by **ds_developer** » Fri May 11, 2007 11:54 am

I don't know if it is the best way, but you can put a transformer between the lookup stage and the sequential file (assuming that is what you are writing to). Then the fields are editable and you can set the values appropriately.

John

abc123 · Post by **abc123** » Fri May 11, 2007 12:21 pm

Yes, I did that already. I was looking for a solution without the transformer for performance reasons.

pradeepleon · Post by **pradeepleon** » Fri May 11, 2007 2:49 pm

abc123 wrote:Yes, I did that already. I was looking for a solution without the transformer for performance reasons.

As John mentioned earlier ,I believe you need an active processing stage to route the data properly.Using any active stage would avoid such warnings.

ray.wurlod · Post by **ray.wurlod** » Fri May 11, 2007 4:07 pm

All you need to do is to set the Null Field Value and/or Default property for each column in the table definition prior to loading it into the job design. No active stage is needed.

abc123 · Post by **abc123** » Sun May 13, 2007 11:17 am

Ray, the stage before the sequential file stage is a lookup stage. There is no way to set these properties in the output tab on the lookup stage because the output link is a reject link.

ray.wurlod · Post by **ray.wurlod** » Sun May 13, 2007 4:15 pm

So set them in the Sequential File stage. It doesn't really matter; the column collection is a property of the link, not of either stage.

Maveric · Post by **Maveric** » Mon May 14, 2007 4:32 am

you can use a copy stage instead of the transformer. lookup -> (reject link) copy -> sequential file. Then you can set the field properties in the sequential file stage.