Handling Null for a Concatenation column

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
reshma11
Premium Member
Premium Member
Posts: 25
Joined: Mon Oct 13, 2008 7:52 am

Handling Null for a Concatenation column

Post by reshma11 »

I have two source columns like AGT_PHN_INTL_PFX length 3 nullable yes,
and second one AGT_PHN_PHN_NBRlength 25 nullable No. I am trying to concate these two columns in the transformer derivation like AGT_PHN_INTL_PFX : AGT_PHN_PHN_NBR. In the target sequential file these two column values should be conctinated. I am running the job source records are not loading.

I am getting warnnings:
Seq_SE_Demo: When checking operator: When validating export schema: At field "CART_ACCPTR_TELEPHONE_NUM": Exporting nullable field without null handling properties
xfm_SE_Demo,0: Field 'AGT_PHN_INTL_PFX' from input dataset '0' is NULL. Record dropped.
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Do a NullToEmpty
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Do a NullToEmpty
samsuf2002
Premium Member
Premium Member
Posts: 397
Joined: Wed Apr 12, 2006 2:28 pm
Location: Tennesse

Post by samsuf2002 »

Or If Isnull(col) then '' else col ...for both columns.
hi sam here
Post Reply