DSXchange

With in a sample job I am trying to use the SETNULL function given by the Data Stage


Can someone help on how to use the SETNULL function?

Destination= SetNull(Source) ?


Thanks In advance.

In modify stage use makeNull()

Thanks for the Suggestion,

Though with this function, my functionality is achieved, just want to understand how I can make use of the SETNULL function in the Modify Stage.



Regards,
SM

What is the syntax for MakeNULL(), Failed to implement this, could you please help me.

Will appreciate if you can give me an example.


Thanks & Regards,
Sm

inputcolumn = make_null(outputcolumn, '<value>')