Problem with Concatenate the string

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ramdev_srh
Participant
Posts: 16
Joined: Mon Jul 24, 2006 9:27 am

Problem with Concatenate the string

Post by ramdev_srh »

Hi All,
Please let me know if I am trying to concatenate two columns from source and loading into target as single column. On source side, one column having value other one is maybe null. Usually if we add string with null we get null.
How can we overcome this problem?

we are using 7.1 server

Thanks & Regards
Deva
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Please post server questions in the server forum.

Use the NullToEmpty Transform

Code: Select all

NullToEmpty(FirstString):NullToEmpty(SecondString)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply