Double to Varchar 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
koolsun85
Participant
Posts: 36
Joined: Tue Jun 15, 2010 3:30 pm
Location: Tampa

Double to Varchar in Modify Stage

Post by koolsun85 »

Hi,

Please help in converting a source field of datatype Double Not Nullable to target field of decimal Not Nullable using a modify stage.

Thank you.
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

Your title says "Double to Varchar" but your post says "Double to decimal".

For Double to decimal use decimal_from_dfloat

For Double to varchar assign source to target field directly in modify stage
You are the creator of your destiny - Swami Vivekananda
koolsun85
Participant
Posts: 36
Joined: Tue Jun 15, 2010 3:30 pm
Location: Tampa

Post by koolsun85 »

Thanks a lot. it worked with Function -As Integer...
Post Reply