DSXchange

Posted: **Fri Jun 25, 2004 10:18 am**

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?

Posted: **Fri Jun 25, 2004 11:21 am**

nvl in Oracle is faster.

Ogmios

Posted: **Fri Jun 25, 2004 3:07 pm**

babbu9 wrote: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).

DSXchange

Padding null fields with # does not work in designer

Padding null fields with # does not work in designer

Re: Padding null fields with # does not work in designer

Re: Padding null fields with # does not work in designer