how can use ISNULL function in datastage

deesh · Post by **deesh** » Thu Jan 31, 2008 7:26 am

Friends can any one seggest the correct method to use isnull in datastage
ISNULL function

ray.wurlod · Post by **ray.wurlod** » Thu Jan 31, 2008 7:45 am

You use it anywhere an expression can be used. In a Transformer stage this includes stage variable initialization, stage variable derivation, output link constraint expressions and output column derivation expressions. You can use IsNull() in expressions in job sequences also. And you can use the function in any DataStage BASIC routine.

just4u_sharath · Post by **just4u_sharath** » Thu Feb 28, 2008 5:19 pm

If IsNull($1) Then '' Else Trim($1,' ')