how to pass Null to default value wit out using transformer

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vsandu
Participant
Posts: 13
Joined: Mon Aug 09, 2010 3:50 am

how to pass Null to default value wit out using transformer

Post by vsandu »

HI ,
i have source with null values ,i want pass the insted of null values as a "NAP"not applicable how we can we perform this
would you please help out this ...
Venkat Sandu
vsandu.cg@gmail.com
BI-RMA
Premium Member
Premium Member
Posts: 463
Joined: Sun Nov 01, 2009 3:55 pm
Location: Hamburg

Post by BI-RMA »

Use the "handle_null" option of the Modify-Stage if You have to avoid using a transformer.

COLUMN = handle_null (COLUMN,'NAP')
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
Post Reply