DSXchange

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.

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

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

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.

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.

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.

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.

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.