Modify Stage Syntax search

Sreedhar · Post by **Sreedhar** » Wed May 30, 2007 3:37 am

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.

JoshGeorge · Post by **JoshGeorge** » Wed May 30, 2007 4:04 am

In modify stage use makeNull()

Sreedhar · Post by **Sreedhar** » Wed May 30, 2007 4:20 am

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

Sreedhar · Post by **Sreedhar** » Wed May 30, 2007 4:30 am

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

JoshGeorge · Post by **JoshGeorge** » Wed May 30, 2007 5:03 am

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