How to convert Nullable field to Non-Nullable field.

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
prashanthgovindaraj
Participant
Posts: 13
Joined: Tue Oct 30, 2007 8:33 am
Location: Chennai

How to convert Nullable field to Non-Nullable field.

Post by prashanthgovindaraj »

I need to convert a Nullable field to Non-Nullable field using a Modify Stage.

Kindly Suggest.
richdhan
Premium Member
Premium Member
Posts: 364
Joined: Thu Feb 12, 2004 12:24 am

Post by richdhan »

Hi,

Search for handle_null.

HTH
--Rich
prashanthgovindaraj
Participant
Posts: 13
Joined: Tue Oct 30, 2007 8:33 am
Location: Chennai

Post by prashanthgovindaraj »

richdhan wrote:Hi,

Search for handle_null.

HTH
--Rich

Can u be more specific please? I'm unable to identify handle_null
Maveric
Participant
Posts: 388
Joined: Tue Mar 13, 2007 1:28 am

Post by Maveric »

handle_null can be used in modify stage to convert nulls to a value. Do a search here on "handle_null" for more information.
Post Reply