Null handling using Modify stage

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
vinayc
Participant
Posts: 12
Joined: Wed Nov 14, 2007 4:38 am

Null handling using Modify stage

Post by vinayc »

Hi

I want to do null handling using Modify stage rather than transformer stage.I am using following function.

DEF= Handle_Null (DEF,'AAAA')

DEF is the column name.
But rather than transferring null as AAAA, it is transferring null only.

Can you please give me some solution?
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Re: Null handling using Modify stage

Post by priyadarshikunal »

vinayc wrote:Hi

I want to do null handling using Modify stage rather than transformer stage.I am using following function.

DEF= Handle_Null (DEF,'AAAA')

DEF is the column name.
But rather than transferring null as AAAA, it is transferring null only.

Can you please give me some solution?
go to learning center and look for

"Modify Stage with Andy Sorrell "

there you can find the things you needed

and you need a premium membership to find all the topics on modify stage. :idea:
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Post Reply