handle null in 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
suneelchallagali
Participant
Posts: 251
Joined: Tue Dec 02, 2008 3:09 pm

handle null in modify stage

Post by suneelchallagali »

Hi guys,

How to set default value to null "date" fields in modifier stage using handle_null function

Thank you,
suneel
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

One at a time, using handle_null() function.

Note that there is an error in the Parallel Job Developer's Guide - the SetNull() function is only for the Transformer stage, not for the Modify stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dashpriya
Participant
Posts: 28
Joined: Thu Mar 09, 2006 12:57 am
Location: mumbai
Contact:

Specification=Col_name= Handle_Null (Col_name,Default valu )

Post by dashpriya »

Please use below code to resolve your query :

Specification=Col_name= Handle_Null (Col_name,Default value )
Post Reply