Page 1 of 1
how can use ISNULL function in datastage
Posted: Thu Jan 31, 2008 7:26 am
by deesh
Friends can any one seggest the correct method to use isnull in datastage
ISNULL function
Posted: Thu Jan 31, 2008 7:45 am
by ray.wurlod
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.
Posted: Thu Feb 28, 2008 5:19 pm
by just4u_sharath
If IsNull($1) Then '' Else Trim($1,' ')