Padding null fields with # does not work in designer

[babbu9]

Hi
I was trying to fill all the null values in a Oracle table with # sign which is the default setting in DS designer. But once i run and look at the output in the oracle table the table still displays null values. I dont know whats wrong.Is there a way to do this?

[ogmios]

nvl in Oracle is faster.

Ogmios

[leomauer]

Hi
I was trying to fill all the null values in a Oracle table with # sign which is the default setting in DS designer. But once i run and look at the output in the oracle table the table still displays null values. I dont know whats wrong.Is there a way to do this?

Did you look using DataStage browser or the other application?
DS browser does not show the "fill" character (at least in files).