DSXchange

How to check if a Filed is null, Is there a IsNull function?

Hi Shree,
Yes, there is a IsNull function.

my requirement is to populate 0000's if the filed is null
I tried If IsNull(myfield) Then 0000, the expression is in red, some syntax error?

Add else to it.

If IsNull(myfield) Then 0000 Else myfield

Hi Shree..
Use the expression given by KrazyKoolrohit.

guys, I am so sorry to post simple ones like this, I have used this many times before and looks like I am getting too dependent on this site at times, just the moment I see a red on the screen, I come here and post it rather than 't h i n k' a while..

Hi Shree..
Do not feel so sorry. This site is to help you and everyone are very cool. I really see DS gurus here.Nothing to feel bad. You will get it by yourself, if not our Gurus are here.

Shree0410 wrote:guys, I am so sorry to post simple ones like this, I have used this many times before and looks like I am getting too dependent on this site at times, just the moment I see a red on the screen, I come here and post it rather than 't h i n k' a while..

All the best..

If you right-click on a red expression, you can choose "Validate Expression" from the menu, and DataStage will report t you what the parser in the Expression Editor believes is wrong with your syntax.

There is also a Transform called NullToZero that you may prefer to use - though it only gives a single zero. You could apply a Fmt() function to pad that with leading zeroes.