Using Null-Handling in Modify Stage

[Teej]

Code: Select all

If IsNull(Field) Then 
    // Whatever you want to assign.
Else
    // pass the value

-T.J.

[adscot]

Hello,

Ah ha a solution. An occasion where the datastage documentation does not match the orchestrate documentation...

From Orchestrate 7.0 Operators Reference

Code: Select all

Field1:string = handle_null(Field1,"NULL") 

Thanks for your suggestions.

Cheers,

Adrian

[ray.wurlod]

It's good value to report these discrepancies to Ascential so that they can get it right next time around.
(Yeah, it's even better value if they got it right first time but they, too, are human.)